Basically, it's not about the camera you use, but HOW you use it. Also, many of the various camera apps found in the App Store can deliver pretty amazing results. Sometimes it just takes a bit of creativity, patience, and a steady hand (which my boyfriend had, but I do not) to get some pretty cool pics.
Have you tried [app=darkroom (formerly steadycam)]this app[/app]? It's great to take steady pics.
This website also has some good iPhone pics.
Also I took this pic with my iPhone, I think it looks really pretty: