Clay,
I was in your position and I decided to take the leap and buy a SLR. If you want a point and shoot, I've seen canon powershot's do very well! Their small and compact so their basically a all in one camera thats easy to carry around. I brought my camera and was showing Jason, Tom, Mike and Jeff some pics. It was an older model SD630 (2-3 years old in technology world means its ancient) but now I've seen a fish tank setting in the newer models(atleast it shows a fish which most likely for tanks). But do your research on that. I still use mine for and love it since its so small. If you have any questions feel free....