Definitely on the Si and Type R (hopefully we still get this in US). It'd be nice if they offered the Si w/ an auto like the ILX. I would like Honda to continue to offer manual on the 11th gen 'normal' Civics as well - it's not like they won't make it for other markets.
Don't want a CVT, don't buy one! Just get an Accord with an auto, or an Acura (if you want to stay within the Honda family). There's plenty of options out there thankfully