IMHO waterviews at moderate resorts are a total waste of money. You don't have a balcony and you will probably have to keep your curtains closed most of the time anyway because people will be walking past your room. If seeing the water when you leave or enter your room is important, then go for it.