Nothing you see in movies actually is the color the eye would see when you were there, right in the action. Everything gets color corrected, regardless of whether it's digital or analog. But especially these days, it is highly likely that the yellow HPS light would selectively be color corrected to something more fitting the movie's atmosphere, since with modern editing tech that's just much easier and more perfected.
Shooting movies with HPS light is and making them look good is very hard, so they might call for just selecting the exact HPS color and turning it a desaturated green to fit an urban dystopia kind of look. The greenish MV look fits urban scenes and 'Neon Underground' much better than the golden yellow of HPS.
It also depends on where they were shot. In the USA, it seems that MV street lighting was the standard for a long time. However, i grew up with LPS and HPS with fluorescents mixed in in residential streets. Amsterdam is still about 50% HPS so any night movie shot in the last 35 years should in theory be either neutral (when it's a street lit with fluorescents, usually 3000k) or golden yellow (HPS). I have never seen mercury vapor public street lighting, only on parking lots etc.
But i'm sure that if you're gonna look for it, you'll find scenes shot under HPS light that actually look the part. For instance - this is a random shot from Drive (2011).
