Petrol engines have earned a stay of execution, but the manual gearbox hasn't. Buy now to avoid disappointment ...