Adorned by the Brooklyn Bridge, San Francisco’s bay, southern charm and artistic flare, these vibrant, residential communities are no snooze.