Dead Horse Point State Park is just as spectacular as neighboring Canyonlands and Arches National Parks. Although it is a fraction of the size, I now consider it one of the 'must-sees' on any trip I take to Moab. The overlook is best viewed at sunrise, and this can easily be done if you stay in the park campground - and I must say it is one of the nicer campgrounds around! Skip trying to stay at the campground in the next-door neighbor, Canyonlands Island in the Sky - the campground at DHP has running water! (No showers, but nice clean facilities, flush toilets, and easy to cook and wash dishes, etc). Beautiful views from the campsites, AND it is reservable - unlike campsites in Canyonlands. But since they are only a hop, skip, and a jump away from I-Sky, you can still easily pop over and check out Canyonlands.
The hiking in Dead Horse Point is also surprisingly great! Last time I was there we did the hike to the Big Horn overlook. As the park range said - it's 'all rim, all the time' - and is now probably in my top 5 favorite hikes in the Moab area (ranked up there with hikes in the Needles, and to Delicate Arch). The views are great, and the terrain is moderate. We did a 5 mile hike in a few hours. Also - not nearly as many people using these trails! We were there in May and didn't see another hiker!!
If you own or manage Dead Horse Point State Park, register now for free tools to enhance your listing, attract new reviews, and respond to reviewers.