Things to do:
Stop by the Visitor Center on the Academy grounds. Watch the movie in the theater. It gives a great, quick over-view of Academy life. I believe you can set up a tour if you call ahead and have that arranged, or if you know a current cadet. Definitely see the Chapel and drive around. It's gorgeous. And look UP! You will see cadets flying gliders and parachuting overhead. It's fun to just park at Thunderbird Lookout and watch.
Places to go: Garden of the Gods, Seven Falls, Pikes Peak--ride the Cog UP, or take a bike tour DOWN!
http://www.bikepikespeak.com/ Our family did this bike tour. It's amazing but be careful... We did have to visit the ER.
The Royal Gorge Bridge is fairly close
http://www.royalgorgebridge.com/ It's beautiful and our kids did some death defying flying-thingee over the canyon.
But by all means GO RAFTING! We've gone with this company twice and they are fabulous
http://www.americanadventure.com/
I hope your son enjoys SS, it's a GREAT time to visit!
BTW, we have stayed at many places-Embassey Suites, Hampton, Drury Inn, Courtyard, and the Best Western Academy. We have never been disappointed. The Best Western was not problematic for us at all. It's older but convenient.
Enjoy!!!