QB Zach Wilson traded to the Broncos

To a point, I agree with you.

I live in Boston and can tell you the organization did not fail Mac Jones. Mac Jones failed Mac Jones by thinking he was greater than the team. His persona on and off the field is what made him lose favoritism.
So was linking him with horrible offensive coordinators a way to humble him? Because truth is, outside of Mac Jones, the Patriots coaching and personnel sucked after 2021. If Josh McDaniels would have stayed, the Mac Jones story would probably be a lot different. But screw him....WAR EAGLE!
Trey Lance looks like he was a glorified combine stud. Couldn't beat out Jimmy G and Mr. Irrelevant Brock Purdy. Lance was a guy that was supposed to change the game.
Objectively, Trey Lance was a raw prospect that didn't have that many games under his belt. Instead of modifying the offense around what he can do, they kept doing what they were doing while not allowing him to develop. The 49ers failed Trey Lance, and moreso because he wasn't Shanahan's guy, and we know how those Shanahans get when they don't get their guy. lol

Zach Wilson looks to be a spoiled rich kid that didn't get his way. His family is more highly touted than him at this point should speak volumes. If he is going to turn it around, Payton is the only person who could do it.
Him being a spoiled rich kid doesn't take away from the fact that he was drafted to one of the worse teams that one could hold for. I can think of many different places that he could have went that would have worked out a lot better for him but at least is he going to a coach that will at least take his strengths into account.

Jared Goff is one that comes to mind; garbage with the Rams and has recreated himself in Detroit.
Crazy thing; Goff wasn't really garbage. His last season, they lost in the division round and the next season, they loaded up. We know what happened in 2022, and this season, they had to go on a 2nd half tear to make the playoffs. All I'm saying is I don't think Goff ever started the season 3-6.

Did leaving help him regain the confidence he needed that McVay curbed stomped? Yep
Was he ever a bad QB? Nope
Was the narrative around him partly due to McVay being the golden child? More than likely

On the surface I agree with the gist of what you're saying, however, as bad as the Bucs have been historically, they did get some juice from a few of the QBs they drafted. The following players had their moments:

1978 1st Round - Doug Williams
1987 1st Round - Trent Dilfer
1999 2nd Round - Shaun King
2003 3rd Round - Chris Simms
2015 1st Round - Jameis Winston
Doug Williams - Seen as a bust for the Bucs. Got the juice in Washington and even then....smh
Trent Dilfer - Took 4 years for him to actually do something and ended up signing with the Ravens as a backup. Now he is coaching my hometown team to a losing record...LOL
Shaun King - Eh....
Chris Simms - No...lol
Jameis - He is considered a bust and can't nobody really tell you why, other than "30 interceptions." lol

If we are looking at their time with the Bucs, Josh Freeman was probably better than 4 of the 5 that you listed. And this isn't even mentioning Steve Young...lol