Best couples resort, not super expensive?

I think one of the most underrated and best value resorts in the Cabo area is the Hilton Los Cabos Beach & Golf Resort.  Compares with resorts that are twice the price.  
It is located farther from the town of Cabo San Lucas and closer to San Jose, which could be a positive or negative depending on how you look at it.  

If you want to be closer to the action, nightlife and partying of Cabo San Lucas, there are other choices that are closer, but the Hilton is still very easy to get into the action in Cabo San Lucas (about 20 minute drive), but very peaceful and more relaxed than some resorts that are closer to town.  It sits on a great stretch of beach thats great for swimming and relaxing too.

If you wan to be closer to Cabo San Lucas, then Grand Solmar Land's End Resort & Spa Cabo San Lucas is a good choice.

If you want to go hipster, party scene right on the main beach close to town with great views of Lands End, ME Cabo (ME by Melia) has a South Beach meets Mexico vibe, complete with Nikki Beach club at the pool.