>>3183132try this photoshop action my man.
https://www.iamthejeff.com/post/32/the-best-way-to-color-correct-c-41-negative-film-scansWhen I used to do all my scans manually this was the best way to do it. Run the action, resize, then do all your normal editing in lightroom. Make sure that the picture of the negative has just the negative in it, no border as it'll fuck up the colours and black/white point. I've attached an example photo with that action
what
>>3183139 said is also super useful