You’re right. Different cars are designed for different places. You want a small efficient car in the city, and a comfy cruising car on the highway.
I’ve driven both types on their home turf and in the wrong environment and it makes a huge difference.
The only truly bad type of car is an SUV. Bad everywhere.