If you ever get a chance to stay at the Marina Bay Sands Hotel Singapore, I highly recommend that you get a room facing the bay if possible.
I think the price per night is about 10% more expensive than rooms facing the other side, but it is well worth it in my opinion. Especially considering that the outward facing wall is essentially one large panoramic window.
If you are wondering what the little white things are in the middle of the water, well they are "wish balls" (now now don't get any ideas). At the time it was just after Christmas, during which for a small fee you can get one of these white beach balls, write your wishes on it, and then someone will tow it out and anchor it in the middle of the Bay.