Yep unfortunately (coming from a household where a family member worked in the Engineering division at Goodyear, so we all grew up driving every make / brand of tyre you could name, and also racing cars), you will NEVER get everything you want in one tyre.
Personally what I've had on mine: You'll quickly find the more you drive on different stuff, that each does something better but will lack elsewhere and never hit all points.
Continental Conti Sport Contact 5P
Comfort - Phenomenal
Noise - Great
Dry Grip - Great
Wet Grip - Good
Wear - Very poor
Dunlop Sport Maxx 050+
Comfort - Good
Noise - Great
Dry Grip - Good
Wet Grip - Very poor
Wear - Good
Michelin PS4 SUV
Comfort - Poor
Noise - Fair
Dry Grip - Phenomenal
Wet Grip - Phenomenal
Wear - Great
Michelin Latitude Sport NO (OEM) so far at least -
Comfort - Fair
Noise - Good
Dry Grip - Great
Wet Grip - Good
Wear - Good
To me, that fact that any street tyre has tread at all - is for wet weather / seasonal performance. So a tyre with poor wet weather is unacceptable period, and barred from consideration. Then, you want a balance between comfort and dry grip, and they must also last a decent amount of time.
The Conti's are great - but they wear very fast.
The Dunlop's are great - but they suck in the wet. Stay away.
The Michelin PS4 are great - but they're uncomfortable and noisy. Perhaps worth the sacrifice, perhaps not.
The Michelin Latitude seem OK so far - but not on the same performance level as the PS4, and won't last as long. You can tell this purely by looking at the tread design, but also feeling how the tyre rolls over / walks on the wheel, as to how stiff or compliant it is. The PS4SUV are hard as concrete. The Latitude are still firm, but more compliant.
Both amplify the smallest imperfections on even a flat smooth road. Where something like the Conti will glide over them. Because they're softer, but hence wear a lot faster.
Having felt the Latitude, and knowing it's homologated as an OEM, you can see why the breakdown above looks more favourable than the others. It does everything "pretty OK", but still lacks a little in one area. A good all rounder. Not a standout in any way, but more balanced than the rest that have a more generic focus towards one area over the others, for all cars.
To my mind, I would question why anyone would want to put the highest performance, track capable street tyre on their crossover or 4WD. Because it certainly isn't necessary at the sacrifice of comfort, IMO at least.
When they say the PS4SUV will "turn your 4WD into a Sports Car", they technically aren't lying. It will certainly roughen it the heck up. If you want the best performance tyre out there, they are absolutely insane as far as all weather grip and wear goes. But personally, I have race cars for that. I want my daily to be quiet and comfortable.