I live in a fairly affluent area. BMW X5 is the #1 SUV around here, with the expected representative mix of Mercedes-Benz, Land Rover, Lexus, Tesla, and Audi. (Cadillacs and Lincolns are somewhat rarer, but still around too)
But as a single SUV model, not brand, Mazda CX-5 is probably #2, which I think says something about their reputation for driving excellence and value. And those I see are almost exclusively Gen-2.
Of course, we also get the normal array of run-of-the-mill Toyotas, Hondas, Nissans, Fords, Hyundais, VW's, Jeeps, and such. But I'd venture to say, about half of those are driven by teens, while the Mazdas, Lexuses, (Lexi?), Acuras, and European brands are driven by parents.
We also get to see the occasional exotic, including SUV's from Maserati, Aston-Martin. Bentley, and Rolls-Royce, all of which have dealers nearby (also have a Ferrari dealer about a mile from my house, but I've yet to see a Purosangue on the road). Closest Alfa-Romeo dealer is a good ways off, so based on the numbers, those might just as well be considered exotics too.
Point being, in an area I'd say is markedly discerning about what they drive, the CX-5 is extremely popular. But, I don't see them quite as often when I venture out into many other areas of the city where Hondas, Toyotas, and their ilk still rule.