My first really good camera was a Nikon Coolpix s600 that I got for last christmas. It was amazing for me, because I've only used the cameras that have no macro function.
For a beginner camera, it will be very good. You can't really take pictures of active fish at all, but if you have snails, or shrimp, or slow moving fish like cories, then you'll be happy.
The other camera that I got (I dropped my coolpix :/) recently, is the Sony cybershot (12.1 MP) It's almost as good as the coolpix, but it's just a bit better quality of image, video, less confusing interface, and it shoots pictures faster (I think).
You won't get an amazing camera unless your willing to fork out the big bucks, but these will work for now until you win the lottery.
The main thing to do is take a LOT of pictures. I take 100 and maybe get 5 good ones haha.