Hi Dave,
I used to run holidays and guide in these areas. What people above have said is all good. It really depends where you want to stay and how much driving you want to do. Assuming you’re flying from Denver, sticking to the I70 corridor will minimise your driving; so that’s Breck/Keystone area (Summit County), Vail area, Glenwood area, Fruita and then down to Moab.
Going the other way, you could go straight to CB (but I’d recommend stopping at Monarch/Salida area) and then on to Moab….possibly consider a detour down to Silverton/Durrango but it’ll be more driving.
Combining the two, I’d probably say a reasonable route to take in some great rides would be:
Breck to CB via Monarch/Salida/Hartman Rocks. BD straight to Moab. Back to Denver via Fruita.
Late August early September may be your best bet to get a balance between crazy heat in Moab and Fruita but still avoid any early snow/crap drizzly stuff in Breck/CB.
I could go on for hours about things you could do and combinations! Love the place! If you want to know anything else, my email is paul at ride-the-world dot co dot uk. – don’t worry we aren’t ‘active’ at the moment so I’m not trying to sell you a holiday!