No, there really aren't that many mid-QB's who make the Super Bowl, much less win it. Johnson and Dilfer had generational defenses. I'll give Flacco and Foles credit and Foles played as a backup. Hostetler did the minimum and won the SB when Norwood blew the easy kick. No one cares about the SB losers.
Derek Carr will never lead or take a team to the Super Bowl. His mental skillset (no route tree, lack of focus) is so below the guys you named, who won or lost it. Carr can't handle the pressures of an approaching rusher, a timing throw, or the end zone. 0-1 in the playoffs in a long-career.
It's funny now to realize the Saints would not play him late, because they did not want to risk the $10M auto payment if injured on the day the league year turns over.
Loomis created this roster and contract dilemma, again thinking he outsmarted the league, when he just falls on his face post-Sean on almost everything he does. He's just an empty suit at this point, turning everything he touches into crap.
Saints should keep Carr for at least 2025. No more restructures, extensions, or dead money. He can enter camp in July as the presumed starter, but he has to compete and they need to develop Rattler and prep him as a starter. Haener, another non-serious and wasted draft pick, can work in the laundry service next year.