My 3 is an automatic. It's the first automatic I've ever owned. When I was looking to purchase my Hummer I searched locally for a manual 3 and nobody had one....so I just went with the auto.
Driving isn't quite as "fun" with an auto tranny - but I guess that's just a personal preferance. With the manual you get the response you want when you want it. I absolutely agree with the statement that with the auto H3, it seems like the tranny can't figure out what gear it needs to be in sometimes.
I guess auto has been a good change for me though. I'm getting older, and I don't feel the need to race with my car anymore - and with the H3, you couldn't do that anyway.
FYI - My last vehicle was an SUV and, like I said, was manual transmission - and I had a hard time selling it. It was in great shape, and I had a lot of lookers on it, but people seemed to run when they heard it was manual. That may just be a local thing though.