I can only talk about Carnegie Mellon where my oldest son studied CS. None of what @austinmshauri mentions is true there. Since it’s a stand alone school, you can’t get frozen out of any courses. There are enough sections of any course and often multiple choices. Uneven professors are common at all schools and you don’t always realize you have the dud until it’s too late to switch. It’s a little hard to tell, but I think SCS has a dozen or so visiting profs at least 80 professors, and a bunch of people with titles like “research scientist”. I’m actually more worried about the overuse of adjunct professors. There were a handful of them.
What I wanted for my kid was for him to be in classes where he was no longer the smartest one in the room. He got that in spades in his classes at Carnegie-Mellon. He also found not just a handful, but lots of kids with similar interests outside the classroom. He had access to great internships, including having to scramble for a second internship when the 2008 economy collapse made the first one go away. The CMU alumni network is amazing and my not very outgoing kid was totally plugged into it. My kid graduated in the middle of his class, but got a job he loves at Google. Could it have happened from a state university? Some perhaps, I have my doubts about any of the SUNYs.
We didn’t mind paying, but if we’d had to borrow money the ROI would not have been an issue. He could have easily paid of any loans within two or three years.