If you wanted that perfect view on vacation, you should buy a fixed week timeshare! That way you would have the view you want all the time!
But - the problem I have is why these rooms are sitting filthy? The OP didn't like their first room, during high season, I would be happy with anything. The front desk should have never moved them without carefully checking out the situation. How do we find out what the problem is with housekeeping, because its not just one resort? But did I read this right that they didn't even end up staying there, left and went somewhere else???