I didn't get the adaptive, but in test drives I thought it did kick the standard settings in either direction - more plush in comfort and firmer in sport. So if you're looking for a more plush ride, the adaptive does deliver that in comfort mode. For my tastes, the more plush setting was not really necessary - I find the stock suspension quite comfortable already, and the plush setting was too marshmallowy for me.
The firmer "sport" setting seemed more to my liking when I wanted to really drive.
I bought my vehicle off the lot, but if I was ordering I'd be thinking hard about adding the adaptive.