I agree cities are generally no fun for vacationing unless you like to walk around looking at the mostly boring standard tourist sites (Sears Tower in Chicago, Space Needle in Seattle). I would add to natural sites to visit:
Smoky Mountain National Park (Tennesse)
Mammoth Cave (Kentucky)
Mt Rainier National Park (Washington)
Yellowstone (Wyoming/Montana)