My most recent purchase was a VW GTI which is an absolute blast. 235hp in a compact car. I'm not sure it's the car I'd be driving though if every car had a manual option.
I like Infinity, Lexus, Audi, but none of them offer manuals.
I think there will continue to be a niche for these. I think a significant percentage of people who buy my car get a standard transmission.