First off, run as far from that Canon deal as you can. Those cameras go for $500 minimum in stores and anyone who's trying to sell you one for $75 is just going to rip you off.
Second, it doesn't matter at all which brand you choose, they'll all be about the same. With DSLR's I shoot Pentax right now, but I'm considering a new Nikon D700 (just announced). If Pentax get's a Full frame DSLR this year I'll buy that so the lenses will line up.
With Compact/hobb cameras I prefer Fuji or Sony. The Nikon's I've evaluated left a lot to be desired, and I can't personally stand anything by Canon (just a personal call, I don't like the feel or menu's).
A good place to go for reviews is popphoto.com, or dpreview.com. No matter what you do, don't get suckered into thinking that Nikon and Canon are the only way to go, many less informed people will try and tell you it is so.
A fun camera that I'm seriously thinking of buying soon is the Pentax Optio W30 or Olympus Stylus SW series. They are super durable and waterproof. You could actually put it inside your fish tank and take photos of your fish from the inside. That's cool right!
OH and Gaz Gun man is spot on when he says to stay under 8 mega pixels in a compact camera. Unless you are getting an interchangeable lens SLR you will lose image quality with anything more than 8 million pixels, and for the exact reason he describes. I'd try to stay closer to 6 megapixels if it were me, that's more than enough to print a good 8.5 x 11 inch print, and 3 megapixels is sufficient to display on your monitor as a wallpaper.
SLC