Pudge signed with the Tigers because he made a public demand of 4/40, and the Tigers were the only team that met his offer, so he had to take it.
Magglio was considered somewhat damaged goods at the time because of his knee issue that he got some controversial treatment in Europe for. Three different teams had backed out of talks with him earlier that week and he did not want to comply with the Mets' demand to have their doctors examine him before making an offer.
We traded for Miggy and then signed him to an extension right away which at that point was the fourth-highest in history, even before he played a minute for the team, but which Miggy said he agreed to because "I like it here. I've got a lot of friends here." There were already four other Venezuelans on the team, including Maggs and Carlos Guillen. I would say that's a clear extenuating circumstance that led to him agreeing to the extension, versus the lure of the Tigers team itself or the city of Detroit. I'll grant that's a debatable point, since we had also just recently been to a World Series, which counts for a lot.
Victor signed in 2011, the Venezuelan nature of the team long having been well-established, and which includied the greatest Venezuelan player in history, which made that a very attractive situation for him.
With Miggy, Victor, Verlander, and young talent like Alex Avila, Austin Jackson, Jhonny Peralta and Brennan Boesch (no, seriously!) leading them to a runaway division title in 2011, that made the franchise a lot a lot more attractive to free agents like Torii Hunter, Anibal Sanchez, Joe Nathan, and, of course, Prince Fielder over the next three years. Because who wouldn't want to come to a franchise loaded with stars, winning divisions, going to World Series, and throwing money around like drunken sailors?
That was a unique moment in Tigers history that we hadn't had before, or since (unless we regard Al Avila signing Javy and Eduardo as a high point in Tigers' free agency history).
Now compare all that to what we have now: a team that's considered to be on the way up—probably—but not only is it not loaded with highly-paid stars, it is, in fact, considered by many around the game to be on the verge of trading away the one established star they do have, and basically starting over. Not only that, but the team is also widely regarded as in the middle of picking a fight with that very same player on his last trip through arb. Whether that characterization is really even true—and it very well might not be like that—that is certainly how that episode is playing out there.
Regardless of how badly Scott Harris might want to sign a top free agent, who's going to sign up for and commit the rest of their career to that situation?
Believe me when I tell you, I don't like it any more than you do.