Well, lots of them are. I don’t think so, I know so 
- freshman seminars, foreign language, Phys 100a or Phys 200a… CS classes are very large everywhere due to increasing demand, and Yale’s added 7 new faculty members to respond to demand. Still, yes, at Yale like everywhere, there are large lecture classes - the only place where an undergrad will only have small classes is at LACs. If one doesn’t want them at all, then LACs are the best solution.
But it’d be disingenuous to pretend the large classes are as numerous and as large everywhere; also, public universities don’t have the means to respond to demand in the ways a very wealthy private university can (and note it took a while for Yale to create those 7 faculty positions. But adding 7 faculty members would simply be impossible in today’s climate at UNC.)
All of this is moot for OP, who doesn’t want to major in Cs nor go to Yale.