Okay
Worst:
MAF Elegante
ELP Wyndham
SMF Arden West
LBB Hotel is great, town sucks.
RSW Crowne Plaza (roaches).
TPA DoubleTree Westshore ^^^^see RSW Crowne

Best:
MSY Marriott Downtown
BOS Westin
CHS Belmond
SAN Sheraton or any overnight Hotel along the water there.