Base on this statement alone Bose system is perfect for you!
Yeah you have to pay premium ($1,130 MSRP) for a mediocre "premium" sound system on the CX-5 Touring, especially comparing it to similar Bose system on Mazda6、CX-9、or even CX-3, as Mazda has removed dash tweeters and doesn't include a sub-woofer in CX-5. But since replacing speakers on a basic audio system won't improve sound quality too much, and replacing head unit is not something you want to do, I think getting a factory integrated Bose system is the best compromise for you.
Besides, once you added the Moonroof/Bose Package, you get a chance to add $1,275 MSRP Touring Technology Package which has LED lightings with Adaptive Front Lighting System (AFS)、rain-sensing wipers、auto-dim mirror w/Homelink、Smart City Brake Support (SCBS) and other goodies. I believe LED DRLs alone make your CX-5 looking more modern and cool, not to mention LED headlights with AFS improve visibility of night-time driving for much greater safety.
the CX-5 does have dashboard tweeters, just no subwoofer