Great little hike but don't let the photos deceive you! There is no access to water (only one little wetland stream towards the beginning). This hike overlooks the resevoir but does not touch water. Very flat to start (first mile and a half) until you reach the foothills. Steady incline with a couple of flat areas. The great views are seen on the other side of the ridge starting by the interpretive signs. Some shady spots but very sparse. There is also a very scenic part of the ridge in the middle of the loop where some of that sandstone sticks out of the ridge. Little less than 5 miles took me 3 hours with plenty of stops in between.
Large section at the start of the trail is flat and goes through the meadows with much of the same view. The loops section was pretty rocky so we unfortunately had to watch our step more than the view, but overall a pleasant hike for being so close to town. I probably wouldn't go out of my way to do this hike again though.
Best if you start from the Michaud trailhead as if you start from the Overland trail head you are going to do just a lot of flat dirt trail walking until you reach the more interesting Foothills trail. Once you do though, it's a pretty interesting hike. nice views and not as many bikes as you encounter on trails to the south.
I think this is the one I've done. The sign called it Reservoir Ridge so perhaps this isn't the right (it's not listed as I read it). Still, if you find this one at the north end of the Horsetooth Reservoir, it's quite lovely. We hiked it close to dusk so the temperature was great and the sunset was awesome.