Welcome from another 2006 XL Denali owner! Absolutely love my Nali! Like you I love the audio setup in these trucks as it has great sound quality, but was disappointed to see the big factory touch screen didn’t have Bluetooth on it. I swapped mine out for an aftermarket unit. I’m currently running a wireless Apple CarPlay enabled pioneer unit that also does Bluetooth and the unit is awesome! Nice wide touch screen but still has home and volume buttons on the bottom. It also has a backup cam attached to it which is priceless for these long body rigs. Like others have stated lots of headunits out there widely available that easily fit the stereo deck in these trucks. It all boils down to features you want and price points. I would highly recommend checking out crutchfield.com, enter your year, make, and model and it will generate a list of what’s compatible for the truck, and you can refine the search to add in criteria of must have features. The site will also let you know what supporting modules you will need to purchase additionally to retain steering wheel controls and the onstar audio chimes as that all runs through the Bose speakers and if you don’t retain that, you won’t have audio at all.
Crutchfield isn’t necessarily the cheapest place to buy the setup you want, but it’s a great source for comparisons on all the different systems and there’s usually a ton of reviews of each product to read through to help you make the best decision.
Edit: nice looking 97 burn!! We love pics around here so when you get a chance show off that XL Denali!