I'm gonna buy a reflex camera soon, but I'm still very pleased with my "old little Kodak", especially when taking night shots. It has a "night pic mode" (like many other cameras now, I guess): I just have to lean it on a pocket tripod and wait 5 or 6 seconds. Some of my latest results:
Almudena Cathedral and the Moon:
The opera house:
A downton avenue:
A fountain with color lights and several water jets:
A mall at the outskirts: