To take macro pics like you all are wanting you really need true macro lens. In order to use a macro lens you need a camera that you can interchange lens. If you have a camera with decent megapix you can take a clear pic from farther away, zoom in, and then crop the pic. I must be honest. With my new Canon it is still difficult and until I get a better lens it will be. Even with crappy cameras though you can still get great shots. The thing about most of your point and shoot cameras are that they tend to focus on what they want to focus on. With a more pro camera (if you want to call it that) you have an option for auto or manual focus and this helps alot. Here is my shot prep list and I know I am not the best, but I have practiced more probably. :)
1. Clean the glass
2. Turn off all pumps
3. Turn off all lights, TV's, etc. that will cause any light on the tank
4. Use a tripod
5. If your camera has a timer option use this. Set the shot up and then run the timer. You can get a remote for just about any camera. I have one. :)
6. Take lots, and lots of pics. I get about 15 or so good ones for every 75-100 shots.
7. Post processing is a big part. Most all if not 100% of very nice pics were edited in with some type of editing program. All the pros do this.
8. Try all different settings. When I am trying to get real close with the limited lens that I have I start real close on the subject. Then I press the button half way as it trys to focus back out real slow until you get to the point it does, then snap the pic. You must be steady to take these pics or you will end up with blur. Blur is caused by the slightest movement.
Here is a great phot site for you. Read it and read it well! He does some great shots with a less that $100 camera from Wally World.
This guy is a hobbiest as well.
Ximina's Photography [Lessons - Index]