Stayed at the Bahia on Mission Bay. Walking distance to Belmont Park, roller coaster and beach (not just the bay). Bay on both sides of the hotel. Really nice. Real close to the freeway. This is the sister hotel to the Catamaran. They have a paddlewheel boat that goes across the bay between the two hotels.
I had a small suite and it was nice. I was there for a conference and was hearing some complaints about the view they had. I didn't dare tell them I got a suite for the conference rate.