Been twice and both flew to Denver.
Found Denver cheaper/shorter flight wise (and direct from UK) where as SLC seemed to go via LAX.
Moab is a bit of a hike right enough and doesn’t really lend itself to any of the major stops (Crested Butte, etc) as at the time of year for riding Moab they will probably still be snow bound (CB wasn’t ‘open’ by end of June last year). That said CB is a very cool place to hang out.
Fruita is worth a stop for sure but unless you enjoy riding in 100 degrees of heat avoid high summer. I particularly enjoyed Joes Ridge and the Kessel Run despite the heat.
Oh and another thing stay in Boulder (not Denver) as like CB Boulder is a very cool place to hang out. It seems to be mandatory to have a bike if you live there. Worth a visit (I’d move there in a shot if I had the chance) 8)