Where to Stay - 5 days in Sao Miguel

When I research where to stay, I see Ponta Delgada recommended often, but I live in NYC and want an escape from the city. Santa Barbara eco-beach resort looks like a great option but after reading some reviews, it seems like the service might be so so. We're pretty discerning travelers, so looking for something that is beautiful with great food and great service. Traveling with a 4 yo so no adults only places. TY!