Didn't he have a similar numbers a few years ago with the Tigers.... only to end up back in the minors and then cut? He's been around for a while and I really wouldn't hold my breath on him figuring it out. I wouldn't put too much stock in the where he was drafted. A lot of top picks don't even make it to the big leagues.
Absolute best case, he's a really, really cheap source of HR while killing your average. Basically his 2004 season. I think that's his upside.
I personally think he still has a large skill set and still has some potential. Though, I think he wasted on the Devil Rays since they don't need offense and have other guys capable of playing 1B. I think he would be a great fit for the Giants. He's be an upgrade over Aurilla at 1B and he's a lefty which plays well in SF. He sorta reminds me of the situation and Adrian Gonzalez was in a few years ago with the Marlins then the Rangers, and finally showing what he can do with the Padres.