Not sure what that movie has to do with "San Francisco" beyond the fact that it was filmed there. You could reword the original sentence:
Anybody thinking buying rental property is a great idea, watch the movie “Pacific Heights.”
My wife has always been against the rental property we owned (one argument I won, perhaps the only one). But after we saw that movie she just looked at me, with the "I told you so look".
I sold our units a few months later.
You can limit to rental property if you want to. To my mind there is nothing redeeming about the place, period.