We are a family of 5 and stay at the Dana at Mission Bay. It's like 1 mile away from SeaWorld. I haven't stayed in their standard rooms (they are older buildings), we always stay in a Bay View room and love it. The Bay View rooms are in some new buildings that were built a few years ago and have a microwave, mini fridge, sink, etc... My wife and I love sitting on the patio at night with our wine watching the boats in Mission Bay and the people out enjoying themselves. I don't know what your budget is, but these run ~$250/night.