Kolb is way over priced (1st round pick + 3rd rounder in 2012 last I heard) and he wants a fat contract extension. That said, some unlucky team will pay for him.
He could thrive with the 49'ers, Vikings, maybe the Titans or Cardinals. But the Bengals/Panthers/Seahawks/Dolphins have too many other needs to pay big draft picks and big bucks for Kolb's services.
The most exciting QB that might be moved (in my opinion) is Vince Young. His career statistics are very good (win %, YPA, Att/Int, ect.). If he can show some maturity, and if someone can teach him how to work hard, the sky's the limit. And he can likely be had for super cheap this offseason.