I have flown in a twin cessna and the work jet, not yet in an RV or single - engine, but there is usually a wide array of various GA planes on the ramp. Generally, the density altitude is quite high, occasionally the winds are gusty, and there is steep high terrain to the east and north but the valley is spacious between the terrain to the east and the airport and down to the south. The south and west are the easiest to enter the valley from, the terrain immediately to the southwest is fairly flat but can be deceptive if on a visual approach to 3.
The airport is not near town, if that's a consideration, but there is car rental at the terminal as it is served from at least four major airports. Fuel is usually not cheap, and I don't think the FBO has amazing friendly reviews, double check their fees.
It is usually a beautiful flight in, especially as we start to get into fall. Some of the best golden color I've seen has been coming into the DRO area.