Given the way the industry works now, I'd be very surprised if there is anyone on APUG who shoots colour, and who hasn't had at least some of their negatives scanned and printed.
I get optical prints when I can, but from 120 if something is proofed for me, it will almost certainly have been proofed using scanning technology.
For that reason, I think I can give a reasonably informed opinion on films and the question originally posed, because I've seen how the films I use respond to both workflows.
If I had started this thread here, I'd probably have mentioned in my post that I would be checking at hybridphoto as well, but I wanted to get an answer from those who were more into optical printing as well.
The Portra NC films perform well both ways, and give excellent results with skin tones, and wedding dresses .
(By that, I mean they hold both shadow and highlight details well, and have natural colour).
With respect to the question of mixed light sources, my advice would be to use the flash and/or light from the outside as your main light source(s), and try to make sure that any other source is both warm (tungsten) and considerably less bright than your flash and/or outside source.
I would also suggest that you speak to your lab and ask them what they would recommend. When you do, be sure that you specify the character of what you are looking for. In my case, I'd be looking for the subtle colour and contrast that the Portra films and optical printing excel at providing.