My favorite would be Flying Fishbone. Great service, outstanding at sunset, and wonderful food. Try to reserve a table at the waters edge.
Next would be Driftwood in Oranjestad. Fresh seafood and great service. Unique décor but no water views. They make their white Sangria using watermelon for a much different taste.