I own a Ford Ranger and a Hyundai Sonata.
I wish the Ford had a manual transmission, for the reasons Orethrius pointed out, but it's an automatic. I bought the truck from my mother six years ago, when I desperatly needed a vehicle, so I didn't have a choice back then.
As for the Hyundai, the V6 model (which we have) only comes with automatic, and the four cylider model which has a manual option was WAY underpowered. My wife can't drive one anyway, so it was out of the question. The hyundai has the 'shiftronic' transmission which is basically a psuedo-manual transmission with an automatic clutch. It lets you change the gears when you want, but it won't let you do insane things like throw it into 1st gear while doing 90mph, or blow up the engine by redlining the engine. It's actually pretty cool. If you throw it into manual mode, you can just leave it alone and it acts as sort of a 'performance mode'. In regular mode, the transmission will shift well below redline if you are at full throttle, but in manual mode it waits till it redlines to shift. This helps out acceleration a bit.