The car industry produces more scandal, drama and intrigue than it does cars. It should be a novelist’s dream, says David Twohig. So why isn’t it?