I have lived in Tampa, St. Pete, and Clearwater in my 7 years in the bay area.
Downtown St. Pete is 50-1 over downtown Tampa.
In St. Pete you not only have the Pier and the bay, but tons more dining, bars, and entertainment venues.
If you would like any additional info, just ask.
Also, you are closer to the beach(less then 10 miles) if you stay in St. Pete, and visiting one of the beaches for a day is a must if your in the area.
I would recommend Clearwater or St. Pete Beach...........