Hey, thanks! I don't really use any special cameras, just a Sony I got on ebay for $200. As much as I'd love to have a digital SLR, I just can't afford one right now. But a lot of the point and shoot cameras out nowadays are super good. I think if you get anything modern, you'll be able to take pretty great pictures with it right out of the box.
I think the key to taking good pictures is more about trying to make them look like what you see in your head when you first think "Oh that'd be a cool picture", rather than how nice your equipment is. Of course, if you've got the good gear, it's going to make the picture even better.