Stay in the Marina, near all the action. Its not loud, but you can walk everywhere, and do whatever you want whenver you want.
My favorite place in Mexico, but I hate all the big all-inclusive joints. I like doing my own thing, so Cabo works well.