With the rise of the SUV, this style of car is increasingly rare. After an inauspicious start, Sean O’Grady test drives an extremely accomplished all-rounder