A decent digital camera for stills and video

[+frankodragon]

I've been putting it off but I'd like to get a digital camera that isn't so crappy. The one I have now takes pictures with flash like a nuclear weapon just went off and the video is grainy. I'd also like to get one that won't get so blurry when I need to take pics up close.

 

To explain what I DON'T want with a camera, here's an example of my crappy train shots:

[+frankodragon]

Update- I did find a camera at a garage sale so I'm putting this thread on hold.