I've flown Skybus three times now for round trip flights. The $10 fares are pretty hard to come by, unless you're planning your trip months ahead of time.
As far as I know, all of the planes on these routes are brand new. I've flown to San Diego twice in the past month, including the very first flight Skybus made out there. The nice thing is that these flights are nonstop - really the only one that I've been able to find between Columbus and San Diego. I paid between $100-$150 each way for the flights, booking about 10 days ahead of time in both cases. I had the flexibility to choose the cheapest flights by day, so if your schedule doesn't allow that you may pay a bit more. However, it was still cheaper than Southwest, and more importantly there was no connection. This cut the time from takeoff to landing from around 8 hours for Southwest to about 4 1/2 with Skybus.
They push the food and merch a bit hard on the flights, but nothing near the point of annoying to me. Overall, flying with Skybus provided no more of a headache than flying with any of the other budget carriers that I've dealt with, and I'd fly them again in the future without hesitation.
As far as going to Columbus as a destination, well, there is actually a strong fine arts scene that has emerged there over the past decade, along with some better than expected dining. No, it's not New York or LA, but culture does exist between the coasts.