Alfa Romeo was once one of the most fabled of all car manufacturers. But of its more recent efforts, only one really stands out. Andrew Frankel reacquaints himself