While we all flock to automatic transmissions, should it really be the automatic choice?