My dad and I stayed there one night a few weeks ago... the Bayfront Plaza. Our conclusion was it was adequate for us...close to the ballpark, a bed, but if we brought our families we would have wanted to be somewhere else. (My dad and I can sleep anywhere)
we didn't tour other than whataburger field, but on a previous trip with my wife, it was quite good for touring. The aquarium, the history museum was good, I think they still have a replica of one of Columbus' ships, the LEXINGTON was really interesting. There are a few other spots, but those were the highlights.