I stayed at the Arenal Manoa about 3 years ago. It was excellent. But I recommend going into town for dinner. The property can arrange a taxi. If I recall, I arranged excursions through the hotel. Maybe a bit more pricy, but easy to deal with on-site.

If you stay at the SJO Courtyard, consider a short ride to the town of Alajuela for dinner. The only food around the CY are expensive chain tourist restaurants. The Marriott is very nice, if you have status.

I did a VRBO in Tamarindo. I did not like the choice of available hotels. Umbrella and chair rentals are on the beach. Tamarindo is fairly walkable. I did not do any excursions at Tamarindo all though I think there were many water-related options available.