We went to El Presidente Los Cabos in San Jose del Cabo. It is nice, quiet and out of the way, a little more tied to nature with a bird sanctuary and some pristine beach, but a quick and cheap cab ride to the shopping, water activities and crazy night life in Cabo San Lucas. It is closer to the airport than Cabo San Lucas but we never heard air traffic noise. You have to go right by it if flying in and staying in San Lucas.
And half way between the resort and San Lucas is Cabo del Sol, absolutely beautiful golf courses that combine desert vistas with ocean views that will take your breath away. It is a Jack Nicklaus signature course. He called the last three holes "the three finest finishing holes in all of golf". The two courses are in the top 6 courses in all of Mexico.
http://www.cabodelsol.com/content/index.html
The swim up bar at the resort pool is great. If you go, make sure you ask them to make you an O.B.
It has been 15 years since we were there, so I can't speak to how the resort is today.