My dad currently has Michelin Premier LTX on his X5. Seems to be a tire with no weaknesses, great ride quality, low noise over bumps and on the highway, handles well, great in rain and snow.
Mother has Continental DWS on her TL. Great ride quality, bit more noise at highway speeds, great in rain and snow.
I have Pirelli Cinturato P7 on my Accord. Almost sublime balance of steering/handling sharpness and ride quality. Quiet as well. Not bad but also not great in rain and snow.