It's like heaven for bikers, with all sorts of trails and playgrounds on the rock. A couple of nice pizza restaurants, plus a big MickeyD's, and accommodation from the cheap and sociable (the Lizard hostel, IIRC) to the more comfortable and pricey (Super 8 Motel etc). I was there twice in a couple of months for a few days each time, but you could easily spend a week or so just biking and going to Arches National Park; more if you go rafting, 4x4ing, or further afield to Zion NP etc. The locals are all very friendly, and if you like bikes, the LBSs are great, although a bit pricey.
Things will be easier if you have your own transport – you can get to Slickrock early in the morning to avoid the heat and the tourists, for example, and some of the other trails are a bit out of the way from the town centre. Personally I wish I'd been back, but I just haven't really had the opportunity.