I have heard good things about Webtrends but it's going to cost you, and implementation is doubtful if your site doesn't receive a certain amount traffic). I've used Clicktracks a little. Our IT guy loves it and the marketing team prior to my arrival hated it, so there is definitely some dissent there. Woopra is also a possibility, but Google Analytics is way better.
I had a painful (and very expensive) implementation experience with Coremetrics. I wouldn't recommend them to anyone under any circumstances.
I totally agree with your comment about Google devaluing their own product. I can only think of one reason why they would go ahead with their "not provided" plans....and that is that they are planning on charging for analytics data that will include the "not provided" keywords (and we'll all be queueing up to give them our $$$).
I am interested to hear from those using Omniture, with which I have no experience.