We just finished booking our stay at the East End in Grand Cayman for our annual dive trip with our grandson. I love The Reef Resort which has now been taken over by the Wyndam. This year we'll be renting a condo from one of the owners of a time share. The nice thing about the condos is that they all have an ocean view--a real ocean view.
I remember several times when we've booked a room with a view and it's been a partial view of the ocean and sometimes only if you stepped to one end of the window and placed your cheek against the glass to be able to see it. I think enough people have complained about the misdirection in the room description that now you get "partial ocean view" in the listing.
There are lots of other views that are spectacular other than an ocean and if you can afford to splurge I can tell you that the views from the Grand Canyon El Tovar Lodge are great. Our room didn't look out on the canyon but we did sit out front often and take in the view. We also visited the Many Glacier Lodge in Glacier National Park for lunch one day and sighed as we wondered what it would have been like to have the beautiful view of the lake and mountains from a room there.
One of the most spectacular views I've seen was that from the lobby of the Jackson Lake Lodge in Grand Teton National Park.
And lest we forget, there are always amazing views from a cruise ship (unless you get an inside cabin). The views of the ocean are generally unobstructed as long as your stateroom window isn't blocked by a lifeboat. Just be sure to check the deck plans carefully. Then there's always the Royal Caribbean ships like the Oasis and Allure and the newer ones that have views of the interior that can be very interesting.
When booking a room with a view be sure to check out several review spots online and get tips on which rooms are the best for a view. Just remember that a view comes with a price and think about how much time you are actually going to spend in that room looking at the view. If it's worth it, book it!