The 2007+ is a world-class SUV and is probably the sportiest mid-sizer not wearing an AMG/M/Porsche S badge. There is a real argument to be made that SH-AWD is superior to quattro in both wet and dry, and it's certainly better than xDrive or 4MATIC.
I've driven a lot of crossover SUVs including some 550 MBs and the Cayenne S, and the '07 MDX still stands out. Night and day vs. the 01-06. Think of the jump from the 2nd-gen TL to the 3rd-gen Type-S and that's the kind of leap it took.
The next one should be pretty impressive. I'm expecting a 9AT and some kind of next-gen AWD, either hybrid or otherwise.