Hey Paul, great questions.
First off, "definately NOT an SLR for fish photography". I'd consider that to be a BIG mistake, and here's why.... DSLR's typically have a very shallow DOF (Depth of field / focus). So, it can be quite difficult to get both you, and the fish, tack sharp.
Also, for self taken shots, the greater DOF of a fixed lens camera, allows you to fudge it a lot more. I set my fixed lens (point and shoot) cameras for 1 meter.... the fish might be a bit closer... I might be a bit further, but with the greater DOF, it's not near the issue.
Now, here's the bad news :-( The camera(s) that I'd most recommend, the Canon A600 series (A630, 640, 650) are not made anymore :-( Luckliy I have one of each :-) It was one of those deals where the cameras did too much, for too little $$$, and it was hurting sales of other more expensive models in Canon's own list of models :-(
As I keep telling people, if you can afford it right now, spur of the moment, I'd start scrambling to find one of the cameras I mentioned above on E-bay or somewhere.... even used, but like new.
Now, when these cameras first came out, they were going for like $149, $189, and $229 (the prices I paid) (from the best online discount camera places). But as people started finding out how great they were, the prices climbed to like $199, $239, and $299.... then even a little higher yet as the last ones were going out.
Anyway, their are 3 primary reasons why I think these cameras are the best for fish photography;
1) because they use AA batts, so you can easily aquire rechargeables, which last a long time, and cost only pennies a charge + help to keep batts out of landfills..... but you can / should still carry 1 set of old school alkalines, which have a VERY long 12 to 15 year shelf life. This means you will NEVER be stuck without juice, on a spur of the moment photo shoot, of the biggest bass of your life.
2) They have an articulating screen which is just the coolest and most important thing ever, when trying to take photos of your own fish, when by yourself. You can see where the top of your head, and the end of the fishes tail is, and make adjustments before the shot(s) is taken.
and 3) these cameras have a function called the "C" (custom) mode. This allows you to set up every possible aspect of the camera ahead of time... aperature, flash, manual focus distance, timer length, number of shots after countdown, ISO.... I'm sure I'm missing something, but you get the point.
So, you stick a big one, your adrenalin is pumping, you can hardly sit still without shaking.... but its okay.... Your turn on your camera in the "C" mode, and its ready to do everything you set it for the day, or the month before.
BTW, you can still tweak things.... like say its a cloudy day. Well, you can leave every thing else the same, but maybe bump your ISO from 100, to 200.... or change your F-stop from say 6.3, to 5.0. If that works great, you can hit a couple buttons to save the change.... or not, and when it is turned back on, on the next "sunny day" it will remember your old / previous settings.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Don't get me wrong, I do own an Olympus DSLR, and its a fine camera for some things.... "when I'm standing behind it" and especially in lower light situations (or my long exposure stuff using really dark filters).
But otherwise, a high quality point-and-shoot for fish photos, all the way ! :-)
Hope that helps,
Fish