I think it depends on what you are after.
Our family had a very enjoyable time. We rented bikes for the time we were there and went biking with the kids, visited the beach house, had fun at the pool, did a bar-b-q lunch in the picnic area, did the "private affair," wandered around looking at the marina and window shopping; movies and games with the kids in the evening at the room, went on the kayaking trip.
You're correct that there's not really anything on site for food (other then the counter service they have during the day), but there's a couple of places just across the bridge and lots of interesting places to eat around the area, though we did a lot of our cooking at the room, we usually ate out for one meal each day.
Like Vero, we used Hilton Head to wind down a little after having a larger family vacation at WDW.