The reliability of manual vs. automatic transmissions is an age-old car debate, but the answer is more layered than most drivers may imagine.