Detroit gets a player who not only can take the last shot in a game, but is looked at as that individual. With Billups/Hamilton/Wallace/Prince... it was always a toss up to see who would take the last shot. And sometimes that is a blessing, and a curse- players are looking at each other to take the shot instead of taking it themselves. Iverson gives them a legitimate go to guy, and a legitimate scorer. He is definitely shoot first, which is something that Detroit has not had in a long long time.
I am obviously hoping that this is like a KG/Allen situation last year- star player wants/desires a ring, past his prime (although it can be debated that KG is still in his prime, but he is definitely getting closer to the end than the beginning), can still put up solid good numbers and bring a high level of play, and needs a change of scenery to refresh/rejuvenate the desire and effort. If the results for Detroit are what Boston got last year, then I am estatic
I like the trade also because it is obvious that Stuckey is ready to be a starter, so one year of Iverson means next year Stuckey is the man in Detroit. Moving McDyess also makes room for more time for Maxiell, although I am hearing rumors/reports that McDyess might come back to Detroit in 30 days (the Brent Barry scenario, presuming that McDyess is waived and bought out which all intensive purposes say it is going to happen).
Detroit needed a go to guy scorer, and they got one. And to be honest, I like the trade for Denver too- they have more than enough shooters/scorers, but they don't have anyone to facilitate and set up the shooters. Billups is a pass first/shoot second player, whereas Iverson is a shoot first/pass second player. I think the trade helps both teams, and makes both teams better.