Moab is definitely just a bad ass awesome place to wheel. Not only is it spectacular, but the rock out there makes for MUCH easier wheeling. I definitely encourage people to make a trip out there. Front Range Colorado is just close enough to make a 3 day trip allright, but I really liked being there for a few weeks. If your drive is more then 6-8 hours, its really not worth it unless you stay for a while.
I have been going to the area for various outdoor adventures since I was a kid, so I don't gape quite as much as some, but its some of the prettiest and coolest terrain and scenery I have encountered. Pics and videos really don't do it justice in any way, both from a scenic standpoint nor a wheeling standpoint. Stuff where you feel like you are standing on your firewall or about to launch into space look like you are just driving down a normal hill. Everything feels and looks bigger in person for sure (though that is true of most wheeling I suppose).