Personally, I never really liked Gallery. It looks a little hokey to me IMO so I opted for Coppermine's Photo Gallery.
My gallery's full of mainly photos I took at events with friends and stuff so there's not a whole lot of excitement, but there is the rare tidbit of artwrothyness
I'm currently using my Canon S20, but hope to get either a Canon 10D or *possibly* the 20D depending on the price... I really want to start getting seriously into photgraphy...