Thats basically the only thing that turned me off to getting a Dodge Magnum last year as my new family hauler (before the wife gave the OK for a Stang). If I went all the way for the hemi option, and all the other high performance goodies, I'd certainly want the stick to go with it. However I guess that Diamler Chrysler decided that not enough people would want that, so there is no manual trans option for the Magnum at all, not even in the planned SRT8 edition from what I hear. The sequential shift auto is no consolation either. Somehow I don't completely agree that thats a good marketing strategy though, look at the Acura TL. It is one of the best performing and nicest sports sedans on the road today, and the automatic is a no cost option over a 6 speed manual. You can't tell me that alot of people are buying that car in stick, yet Acura still offers it. If they can do it, other car companies can to. Granted it's not always easy to get one, a friend of mine here at work just bought a TL last week (automatic) and the sales guy told him they haven't had a stick car on the lot in weeks. He also said they weren't to worried about it, since they aren't selling to many in manual.
I thought I saw a preproduction TR8 coupe a few months back on Ebay that was a manual, a red one if I recall correctly. Could be mistaken, my memory seems to be going the same way as the transmission in my Volvo lately, slipping when it gets overused.