Unless you want to try your hand at taking pictures for magazines, and you might, that Pentax Optio WP series is excellent – probably the best fishing camera on the market.
The higher end DSLRs with the underwater housings become extremely bulky – almost the size of a women’s basketball once they are all assembled.