Cowboys took Aikman #1. Broncos essentially took Elway #1 when they traded. Ditto NY Giants for Eli. Colts took Peyton #1. All those teams got Super Bowls out of their #1 overall QB picks. That’s just off the top of my head. I’m sure there are a couple more in NFL history.
Has there ever been a team take an OL #1 overall and win a Super Bowl?
Orlando Pace. No. 1 pick, on the short list of best to ever play. Ron Yary was also taken No. 1 and he didn't win a Super Bowl, but led his team there four times. Eric Fisher actually was taken No. 1 overall and did win a title with him, though he hasn't been all that. Jake Long was only a four-time Pro Bowler.
No. 1 overall QBs beside the ones you named (I'll start in 1960).
Terry Baker - Three seasons and done
Terry Bradshaw - Four titles, though he was kinda in the Aikman category
Jim Plunkett - Won two titles with another team
Steve Bartkowski - Generally good QB, no SBs
Vinny Testaverde - Didn't do much for Tampa
Jeff George - Yeesh
Drew Bledsoe - The epitome of pretty good, played in one SB
Tim Couch - Yep
Michael Vick - He was fun
David Carr - Won a ring with Eli
Carson Palmer - Played a few snaps of a playoff game with the team that picked him
Alex Smith - Peaked in SF as a game manager and was replaced by a sometimes-good passer
JaMarcus Russell - Oof
Matthew Stafford - Yer guy
Sam Bradford - Ouch
Cam Newton - MVP that no one is signing
Andrew Luck - Pretty good
Jameis Winston - Available
Jared Goff - Did lead a team to a Super Bowl
Baker Mayfield - Who's to say
Kyler Murray - Pretty OK last year
Basically, as soon as everyone said "We need good QBs" more than needing good RBs, the quality of No. 1 overall QBs fell off.