It's pretty cool by Community College standards. Most students consider the Grant/Brentwood campus to be the best campus out of the three b/c most professors there are somewhat decent and it is by far the best looking campus (especially compared to Nassau Community College which is very dated-looking). All of my classes sizes at SCCC have been reasonably small.
Just watch out for the speeding Honda's through the parking lot and avoid the Sagtikos Parkway around rush hour and you'll be fine.
Bill: Cool, bro. Just don't get ran over by a souped up Civic or a bmw w/overly tinted windows.
Sam: Dude, it's not that bad!