Some specific condos to look at on Curacao.
We stayed at Piscadera Bay Rersort - they're older 2-3 br duplex condos across the street from the beach. They share a beach with another nearby resort. No pool on the property.Surprisingly huge yards - most private. Mu 2br condo had a big enough table for my group of 7, another one outside on the deck and a 3rd in the yard. Full appliances including a washer/dryer. The way they run up the hill most have water views.Gated, fenced and they patrol at night.
The Hilton across the street has a small casino. There's a handful of restaurants nearby and it's 5mins. by car to north Willemstad and the swinging bridge takes you to the south side of the harbor and all the shops/restaurants etc.
I believe the Hilton also sells a day pass but their beach is meh.. There's another condo property there called Royal Palms - also about a block down the hill to the water but they have a pool. I think their nearest beach is a small one we stopped at once - no one was on it mid-morning. We were hoping it was a dive but it was too flat.
I forgot to mention in my previous post that Lions Dive has some condo-style buildings with kitcchens. Also the Royal Sea Aquarium condos are across the channel - not sure if they have a beach. The main Ocean Encounters shop is also there.
Once you leave town, it gets quiet fast. So although there are some condo options if you took the car you'd be stranding them. If that's not an issue, look at Lagoon Blou in Lagun - they're nice, overlooking the water, down steps to Playa Lagun beach and there's 2 restaurants there. Plus a good shore dive and Discover Diving at the entrance. It's about 30 mins to town from there and we did it twice to find somewhere to eat. Far enough from town that Centrum Market south of the airport offers cheap coolers/dry ice if you shop b4 driving out. It's really quiet at night.
A few minutes north of town is Blue Bay resort. Decent beach, good wall dive, nice place. Two different sets of condos - some on the water, some up the hill around the golf course so check the location. It's a few minutes from Piscadera for more food options or about 10 to downtown.
I've been to all of these except RSA - or at least stayed nearby and went past them often.