Good trade for both teams, but I like it a lot more for Detroit. Guess I am alone with that thinking, but I love it for the Pistons. A big part of this trade is the fact that AI's contract will come off the books after this season. Not many people are discussing that. Also, the Pistons had not won anything substantial the last several years. They had to change something up. If it doesn't work this season, AI is gone and they have tons of money to work with.
As for Denver, the Iverson and Melo thing never worked. Nor was it ever going to. They had to make a move as well. Getting Billups is nice for them, he gets to go home. The only downside is the fact that Billups has a monster contract with years left at big money.
Overall, I think the winner is Detroit. They shed the big contract of Billups, get a proven scorer in AI, and have the chance to have over 20 million in money to spend going in to next season.