there is plenty of room for a game-manager-type QB in this league too.
I do think Alex Smith among the 32 best QB's in this league so yes there is room for him.
By my subjective count, which I'll address below, it's been 12 years since a game manager QB led a team to a SB win. In fact over the last 21 SB winners I'd say only one qualified as what I consider a game manager which of course was Dilfer.
Looking at another way out of the last 21 SB winners only 2 of those QB's are not in the HOF or strong bets to make the HOF and those two are Dilfer and Brad Johnson.
What is a game manager is of course subjective but with most of these QB's there is little debate. You could debate Brad Johnson but he was strong that year so I'd hesitate to call him a game manager but think it would be fair to label that as a situation were you can win the SB with an average QB. Big Ben's rookie year is really the only other debatable one in my opinion and while he did play most of the year like a game manager his elite talent level was evident and he had a strong game on the road in Denver in the AFC Championship game.
49'ers are of course a legitimate SB contender. It's been difficult for the past 20+ years to win a SB with a game manager type and now it's more of a passing league than ever before. Alex Smith should be good enough to land a starting job on an AZ type but he should not be the QB on a SB contending team. Evidence just suggests it's becoming increasingly difficult to win the SB this way.