I'm not making excuses for his behavior, but Ben Gordon's really not the type of player who belongs in Detroit or Charlotte. He's a guy who was meant to play in big games - he craves the big moment, the big shot, etc. He's already proven that in the right situation he can win you two playoff games. I posted last year that the Clippers were the perfect spot for him - he's virtually the same player as Jamal Crawford, who has had an extremely positive impact this season.
Ironically, Chicago is the best fit for BG right now, IMO. The Bulls desperately need another scorer, and his defensive flaws could be partially masked by Thibedeau's top-notch defensive schemes. If Nate Robinson can play minutes for Chicago, BG would have no problem playing 30 minutes a night and taking shots in crunch-time. Memphis would be another ideal destination for him. Similar to Chicago, they are one of the stingiest defensive units in the league desperately in need of a two guard who can space the floor. Him and Tony Allen would basically be the perfect offense/defense tandem down the stretch.
Unfortunately, BG's contract makes him difficult to trade. So he needs to make the best of a tough situation for another year or two.