The Foundation Room at Mandalay Bay has a great view . . .but it's a private club. The Mix Lounge is your best option.
Now, it it's a hotel room, a south facing room at Treasure Island is an AWESOME view.
Or, take Spring Mountain Rd West to Durango; park in the parking lot at Carl's Jr; and enjoy.