We stayed at the Hyatt in mission bay
https://m.youtube.com/watch?v=xsbad8GEW78
Cool thing about the hotel was you could take the water taxi to the aquarium. Our room also faced the aquarium, and we got to see the fireworks every night from our room.
As others have nmentioned, the aircraft carrier is very cool, it is interesting talking with the docents.
Go go the gas lamp district and get your eat on.
I also found it really easy to drive around there.
When we were at Coronado beach a jet fighter came screaming down the shore line at a relatively low altitude, it was just cool