My wife and I went for our honeymoon 6 years ago and stayed in San Jose Del Cabo (a 20 min drive from Cabo San Lucas); amazing place. I can't recommend any kayak fishing because I wasn't into it then, but as far as charters I HIGHLY recommend a Panga trip. Its exhilarating having a guide that doesn't speak english but is an amazing fisherman and guide, we learned key words quickly
. We booked it through the place we stayed and there are probably dozens of companies that do it, but quite the rush and at a bargain price. We caught 4 gorgeous Mahi on a 1/2 day trip only 2-4 miles from the beach and paid maybe $275 for the trip. Good luck and enjoy!