I've been there on business. Indeed not much going on cycling wise.
I find "wannabe pros" an odd comment. Even the Cat 1,2,3 racers I know don't expect to become professional racers, they are engineers and machinists and such who like to compete. If you just mean people dressed in lycra on drop bar road bikes riding hard, that's just a form of recreational cyclist. Maybe not pertinent to the topic of Greenville cycling culture, but than again maybe it is. If you're looking for camaraderie, they might be friendlier than you expect. Unless you call them wannabe pros. Opponents to cycling would certainly be happy to see divide and conquer is working.
Having said that, I wouldn't live there. Active lifestyles isn't really a thing, and the pull of local culture is strong.