I must admit I’d love to see a Stargazer-era Picard. His “origin story” if you will.
Picard taking command of the bridge, learning to become a captain. To me that’s a more compelling idea than Picard’s life after Nemesis.
That being said, we’ve already seen the Stargazer and we know what she looked like thanks to “The Battle” and the ship and aesthetic, etc. would inevitably be changed for modern TV. So maybe going forward to a time when aesthetic trends and conventions don’t apply (because they’ve not been invented or seen yet) is the way forward (pun intended).
Maybe if we'd stop complaining as a fanbase about "aesthetics" and "TEH CANNON!!1!" and things of that nature, we'd get a really good show (like what you've proposed here) instead of something that is a third-tier choice because they are terrified of fan outrage.