Folding bikes are great solution if you want a bike that you can store in a small space.
I'm not sure what Camping World sells, but their stuff is usually relatively expensive, so if you're okay with what something costs at CW, you can probably get something better for the same money elsewhere.
What you get depends, as always, on what you're willing to spend. If you just want to ride around the campground or around town a little, a cheap one will at least get you out there riding. Or you can go high end like we did with this one, which was ridden for thousands of miles on mountainbike trails all over the country:

A folding bike will be more expensive than a regular bike of similar quality, and you'll look stupid while riding it, but if space is the only thing between you and riding, then I think it's a worthwhile compromise.