Great question — answering as the UphillTech team:
In my experience, most of the trailheads in the Boulder, RMNP area are accessible to little cars almost the whole time they are open. I'm not saying all are, but most. That said, you could easily go three ways with the choice of vehicle: AWD, little clearance -- Something like a Subaru will get you to almost all the trailheads that are open almost all the time. You might occasionally have to pick a different trailhead, but most of the time it'll be just fine. (This is what lots of people would recommend, with good reason.) 4x4, high clearence -- An Xterra or similar small suv on a truck frame, will get you to basically every trailhead at any time. I personally wouldn't go this route in the...
Full answer by Joe Manlove: https://outdoors.stackexchange.com/a/8007 (CC BY-SA 4.0).
Need it done for your business? UphillTech.