Giant roadside attractions have helped put hundreds of communities on the map. What happens when their novelty fades and costs pile up?