I found Comfort too soft, especially around "tigher" curves, car was moving around too much. Sport was too bouncy (amazing how bad some pieces of Autobahn were). Normal was the best compromise for me.
Drove over 4000 miles in Europe, probably more than half of which was on highways.
2015 F80 ED
2004 Z4 3.0
2014 X1 28i ED