Its gestation was convoluted, its lifetime cut short, its sales far below expectations. But, as Richard Bremner reports from behind the wheel, it was by no means all bad