I think Miami, Orlando, LA and NY are always going to be the most attractive destinations due to weather and/or glamour, but Boston certainly has a shot at top free agents with the winning tradition, two all-stars in Rondo and Pierce, reputable management and. It's not like we're Minnesota.
It would be really hard to lure a guy like Howard from Orlando though.
I could 100% see Doc luring Dwight from Orlando.
Going from Stan who rides his guys in public like they are the MBTA to Doc who is the ultimate players coach (in the public anyway), would be like releasing the world off of Atlas' shoulders (Dwights shoulders might be bigger).
We finally have a coach who guys want to play for. Doc is respected league wide. Shaq wanted to come here and play for Doc. I think Dwight would too.
also Dwight Howard and Bill Russell seem to have a relationship similar to KG and Bill Russell, check out these videos.
http://www.youtube.com/watch?v=Vu0zYKVGxOQ
http://www.youtube.com/watch?v=nlbEzg_t6Ec
He is going to be the greatest defensive player of his generation, much like Russell. After he fails to win a championship these next 2 seasons and see's that he doesn't have that other superstar you need to win a championship and compete with the heat for the next 5 years, he will see Rondo and the Green and the legacy he could have if he wins multiple championships in a C's uniform 
The Celtics and Magic have really battled over the years so it's crazy to think about on one hand.
On the other hand, the idea of playing for a good defensive team where not so much pressure would be on him to be the teams only real defender and rebounder. And playing with Rondo, a creative PG instead of just a shooting PG like he has had, has to be appealing. Look at the Rondo to KG alley that we've seen over the years and imagine a Rondo to Dwight one... wow.
And I think SVG is a smart coach but I think the "Master of Panic" label is well deserved. He is ultimately not that good of a coach because of it. And Doc probably could lure him as a player's coach...
That being all said Chris is right in pointing out Doc may not be here.
It'd be funny because if Dwight came here he'd go from maybe my most hated player to one I'd probably love. He is such a great defender.
Dwight is really your most hated player? Im curious to why... I think he is an awesome dude. hes funny, hes exciting to watch, and he really brings out the passion for the game in his play and in his off court activities.
I don't hate him like say how some people on this board might hate LeBron. I don't think he is a bad person or any of that.
I am a Celtics fan raised, but am a fan of LeBron and the Cavs (used to live in Cleveland for a while) and so I've always had that LeBron/Cavs vs Celtics rivalry over the past few years as a kind of weird thing where I always wanted us to win but still have LeBron and the Cavs do well.
So in the East it's always been Magic vs Us as my big rivalry. And while I respect Howard very much as a player, I have rooted very hard against him. He has virtually no post game so I love hating on him for that and his "all smiles" demeanor is fine, at times it's too much. And he throws elbows like a mad man somtimes, and while some of them are uninentional if still super dangerous, some have absolutely been intentional. To be honest last season's playoffs made me have some legitimate hate with the elbow throwing but we will see. It's not something he does consistently but in our series it got WAY out of hand.
And my dislike for the Magic in general also throws him in. Especially Stan Van Gundy, who I think is a smart coach but incredibly unlikable and undependable. Again, definitely the "Master of Panic".
All that being said I think he is an incredible defender, one of the all time best, and rebounder. And he has been asked to bear a huge load over the years unfairly and unsoundly IMO in Orlando.
So basically, for me "hated" means I root against him like crazy. I only "hate" players within the game, on the court, so maybe hate isn't even the right word. But for me I wouldn't even consider "hating" a player personally for the way he plays a game or handles his business around that game so maybe I shouldn't even use the word.
And like I said, he dons the Celtics green and I love him for the rest of time. So that shows you how my "hate" works.