I'm curious what all of you use for a car transmission.

The car we have now is a manual transmission, and it's the first stick-shift I've ever owned or driven. I wanted to learn, so I figured I may as well just buy one sooner rather than later. It was kind of rough at first, but by now I don't really even think about it. I've had it for about 3 1/2 years.

We will eventually need to replace the car, and the other day I was wondering to myself which type of transmission we'll end up with next. I concluded that it will probably be whatever we can get the best deal on, but I think I'd prefer a manual transmission, if only because they seem to have a lower failure rate than automatics.

So...the point: what type of transmission do you have in your car and why? Do you like it? Why?