Probably, the area on the Gulf of Finland is a good viewing point in Saint Petersburg. If you want to have an aurora-viewing stay in Saint Petersburg, do not plan it on summer. It's a white nights season, so at most you will see the sky lit up with sun rays (which is anyway very romantic and charming).