There's so much to say, I'm not sure where to start. I've owned or programmed most of the scanners you've mentioned. I have an SDS100, SDS200, Whistler WS-1065, BC125AT, BCT15X, an APX4000, 4 MotoTRBO radios and more amateur and professional series radios. I am retired LEO and I worked for Utility Communications for 14 years. (Don't judge me) I did a LOT of programming of all the above-mentioned radios and more.
That being said, with the state system being P25 Phase 2, your best option is the SDS series. It's designed for exactly that and works pretty well. It takes some dedication to figure out how to program and operate it. It's not easy. If you plan on listening in the car, the audio is very disappointing. You'd need an amplified speaker.
Your post explained a lot of your background and radios, but I didn't see what the aversion is to the SDS specifically. It is a ***** to figure out but once you do, it's a good digital radio. The analog side of things is pretty disappointing which is why I have some of the other radios. I have mine set up with a ton of different "banks" on the CSP system that I can easily turn on and off depending on where I am and what I want to listen to. Looking at your profile, you could take huge advantage of this when traveling. My parents are in NC and when I travel there, I just press a few buttons and I'm monitoring those local agencies.
If you'd like, message me here and I'd be happy to chat and assist in programming.