I'm not familiar with the Sony Movie Studio, but your great idea, shooting with a lot of light first then darkening the image in post, is what I would personally do.
I could be wrong (someone please correct me if I am), but I would start out with using Day4Night filters if such thing exists...