gdolby sounds like you have a pretty good digital and a 10x optical zoom is more than 80% of them have I'd say.
I think I understand your frustration with the zoom though. I purchased a 12x zoom last fall and the stuff that is close in the ranges you mentioned 40-150 yards I also felt the results were dismal. Where the zoom really shines is in the stuff way out there. I am very pleased with the stuff 400 plus yards away. The following two pics were taken standing in same spot.
I bought the Sony 12x zoom and they do have extra lens: more zoom, close up and wide angle for a very fair price. I may try them since they are fairly cheap since the next option seems to be a Single Lens Reflex (SLR) digital which has a ton of lens to zoom out there with but the prices are steep.
What about video? You can get 32x zoom on some of them and the prices are pretty fair these days.