In St Petersburg you're spoilt for choice but I think you definitely need to visit these locations..I was there on a guided tour so didn't have much option with lighting but hopefully these give you an idea...
STS Peters & Paul Cathedral

Peterhof Palace
