Only two compact cars on sale today in the US offer manual gearboxes. What happened and what does the future hold?