I live in Curaçao. If you are looking for a place with no rocks and a sandy bottom in the water, Renaissance is the place (this is a man made beach like area, salt water infinity pool, no snorkeling), it very nice.
If you are looking for a real beach, then choose either Avila or Marriott, both are a bit rocky, but have good snorkeling.