It is very hot there this time of year, although June is a couple of degrees cooler than July and August. Be prepared for temps well into the 90s.
If you like art, the community of Todos Santos is an easy drive just up the Pacific coast from Cabo San Lucas. Lots of galleries and shops.