I've got a stick in my '01 BMW 325Ci, and wouldn't have it any other way. BMW has the option of a 'steptronic' which gives you a 'sport mode', but, imo, it isn't even close to a good compromise. If I were to buy an Accord, I would get an automatic, no doubt. But, since I bought a car so I could _drive_ it, I wanted the stick.
I love the bimmer. I don't think there's a better (affordable) car made. There are certainly many other cars that could pacify my bimmer straight off the line, but I didn't buy it to race those who feel they need to try and compensate for lack of something (I say this, because it happens quite often at stop lights).
So, if you're buying a car to get from a->b, get an auto. If you bought a car because you want to _drive_ it, get a stick.