Most of the hotels target the business travelers - less biz travelers to national parks.
That said, I love the Residence Inn in Harrisonburg, VA - it's about 30 minutes to Shenandoah Nat'l Park. There's also several that near the Smokey Mountains in TN. Yellowstone, Grand Canyon, and the like are more "remote" areas that are so big that there's not a lot of surround infrastructure to support year round business (other than National Park business, which is very seasonal).