Brett had an easier in here with the fans. The team had barely a shred of hope under Majik man and then Brett showed up and it was party time. People did not have huge expectations on the team early on in his career, like they do with Rodgers. Hope, sure, but expectations? Favre was free to drink, party, not study the playbook hard, etc. i.e. be Brett, while Rodgers has had to be a practically flawless ideal of how to handle the situation and he has still received criticism and some downright rude shit from Packers fans.
That's not "souring" on Favre. That's taking a step back and looking at his career here objectively, which has been so mixed in with real "souring" that the two get muddled.
I prefer to just look back at the Favre era as a time, and not focus on the player and person himself. A lot of pieces had to fall right into place for Favre and the Packers to have the success they did. Heaping the praise all on one individual is silly. And I can't really say that I admired him a ton off the field, because he was a wreck until he got too old to play that shit any longer.
And pack93z, that just comes with the territory. Favre probably didn't deserve the ridiculous amount of adoration that he received from fans either. Taking the good with the bad comes with the territory/fame/money.