Centrepoint optimizes sound for drivers position, but its effect is not dramatic and only works on some inputs.
IMO, The 225W Bose system is good, but not great. I liked the stock 350W system in my old 2007 Civic better and I had to pay $1200 to get the Bose upgrade in the CX-5. That said, I wouldn't get CX-5 without Bose because the base radio sounds so bad. I got $1700 off msrp, so I figure I got the Bose for free.
IMO, the Bose center dash speaker overwhelms all other speakers. The rear speakers can not be heard unless you fade 90% to the rear. The highs and mids sound fine, but the bass is lacking.
The head unit has a number of notorious issues it shares with the base radio; USB resets to first song everytime you start car, shuffle isn't very random, USB stick reloads everytime you start car and could take minutes, selecting Shuffle on USB stick picks initial random song, but following songs are sequential, iPod nano isn't useable as worst problem is every 10 minutes a song will turn into blasting white noise. Bluetooth to my Android 2.2 phone doesn't show song titles, but otherwise works okay. The CD functionality has none of the flaws USB or Bluetooth so I listen to that most of the time. The FM digital reception is nice and not many cars have that. I haven't listened to FM in years, but digital reception makes it tolerable.
Bose is worth it on CX-5, but its not perfect, a quirk of the CX-5.