Here's a thorough review. Sounds like it would be best to wait a year or 2 to buy one.
I rented one of these last week on vacation via Turo. I've owned several Mazdas including my current 6 turbo and I like Mazdas overall, but I was not impressed with the CX-90.
I found the following two statements (I'm paraphrasing) from the powertrain engineer in the above video particularly cringeworthy:
1) 'We designed the transmission without a torque converter to allow it to be skinnier for packaging purposes.' But the center consol is wider than most SUVs with more wasted space, and the under-consol storage is pathetically small (a point made by the critics in the video). So where did the extra packaging volume go???
2) 'We designed the transmission to provide flawless power delivery from a stop.' But this car's transmission had by far the worst low-end power delivery of any car I've driven in a long time. If I didn't come to a complete stop at stop signs, when I pressed the accelerator down again there would be a 1-second complete loss of power before it reengaged. Actually made me a little nervous a couple of times when there was another car coming down the street that didn't have a stop sign. And when I did come to a complete stop, when I pressed the accelerator lightly to accelerate slowly, the ridiculously short 1st gear would change to 2nd in a split second, again interrupting power delivery. It only performed smoothly when I aggressively accelerated from a stop, which very few are going to do in a large crossover like this.
I did notice it had an April '23 build date so it's probably one of the early builds and maybe it hasn't had all the available software updates yet.
Other aspects of the CX-90 I didn't like:
1) Overly harsh and jittery ride over uneven / broken highway surfaces. Worse than my 6 with summer tires.
2) Overly large and underutilized center consol (mentioned above)
3) Grabby brakes - when I was trying to slowly get closer to a wall in a parking garage inch by inch I couldn't do it smoothly
4) The AC button is way on the right (passenger) side of the center stack, beyond even the passenger seat's heated seat button. Relatively minor but I started getting irritated the more I needed to press the button when it warmed up in the afternoon.
5) I don't care for the rear-end styling - looks bulbous and out of proportion to me.
6) Steering is overly heavy at low speeds / in parking lots. Same complaint I have with my 6.
I will say the base turbo 6 is definitely smoother and quieter than the turbo 4 in my Explorer. Though the 310 ft-lbs of torque in my Explorer (RWD) is much more noticeable in everyday driving than the 332 ft-lbs in the CX-90 (AWD). The Explorer just feels quicker in general.