Digital Cameras--waterproof and macro (fly pics) capabilities

Any thoughts on the best cameras for under $300.

I want to be able to take decent pics on the stream, as well as take pics of
flyz I have tied or used to catch trout. I realize $300 probably won't buy
the best on the market, but its all an uneducated hillbilly like myself can
afford, presently.

I trust user opinion much more so than anonymous camera reviews, so please
let me know what you use, recommend, or would not recommend.

Thanks guyz,
Op