I just play Madden 07 Franchise Mode as recently as 3 weeks ago and had a blast. I think what made it so good was how deep the game was. The Franchise Mode was ridiculously deep with being able to go in and set each teams gameplay, putting percentage amounts on how much PT you wanted your first string to have vs second string. The player morale, the team/opponent weekly breakdowns. The emails, local and national newspapers and the Tony Bruno show just added immersion. The on the field play was good for it's time and the superstars played like superstars. The college all-star game. Add to that Owner Mode where you could set ticket and concession prices and do forth and that game was jammed packed. I started a franchise and got to week 2 when I stopped because well....
I bought a Next Gen console lol. All of my attention has been there. But anytime I want to experience nostalgia and a really deep franchise experience I can always go back and pick up where I left off.