Off-campus is better. Less traffic, easier parking, plus there are many ways to shuttle to the stadium from places like the Colonial Life lots, etc.
Columbia is in a city and the green we've added is awesome, but we're still in a city that's growing exponentially, so we're never going to have the traditional scenic views. And I like it that way.
If you prefer farmland and nothing to do, Clemson is way better. There are about two bars and some chain pizza places in Clempson. I'll take Columbia literally any day of the week.