I can highly recommend the San Francisco Bay area at night! Its always a pleasure to fly into Oakland or San Francisco. And as previously posted: Las Vegas! Beautiful during the night. There are so many lights that even if you are flying IMC, you will notice you are flying overhead Las Vegas. The clouds are so much brighter.
As far as the FBO's are concerned, I have had some good experience with the Palm Springs' FBO.