When I went to the NASCAR race in Darlington, I accidentally sat on my camera disabling the zoom mechanism. Fabulous. So, per advice given by a few very knowledgeable camera dudes, I decided to just suck it up and buy a whole new camera (rather than get mine fixed).
I went with the Canon Powershot SD1000. It's got 7.1 megapix, 3X Optical Zoom, 4X Digital Zoom and is a lot smaller than my previous camera. I'm happy with the choice and should have it by the end of the week. Now I just have to learn how to use the darn thing!