Not really. I bought the fujimax s5k 3 MP/10X optical last month. At the same price I could have gotten a 5 megapixel 3x I think, but I wanted more zoom, and really once you get up in megapixels the only benefit to them is if you're printing large pictures. If you've got a 25 megapixel image but you're printing an 8X10, or you're shrinking it down to 1024X768 for the internet, you're just wasting capture-power. 1 mP will do great with 4X6 and 3 megapixel will do great with 8X10 prints (these estimates are large though, based on what that link above says about the myth of megapixels).
A benefit of a huge megapixel shot is that you can crop it later on and still maintain quality. Alternatively, if you can't zoom in to something close enough you can take the huge shot, and then digital zoom it yourself at home later, and if it had enough pixels to begin with the digitalled zoom will still be good. In my case I just went with a high optical to begin with, even though it's only a 3 megapixel shot. A 10X optical with 3 megapixel will give better definition of an object than a 10 megapixel shot unzoomed (if you plan on cropping out the same section from that 10 megapixel shot to try and mimic the zooming of the other).
BTW, you probably know that digital zoom in cameras is a total waste of money. It's horse crap and you can do the exact same thing later with photoshop, if you're interested in cropping part of the image. Optical is the only important zoom you should be looking at.