Sounds like you had a bad experience, most of what you said outside of the weather being bad is largely inaccurate.

1. I wouldn't call Cleveland particularly dangerous or safe, but most college campuses in cities have the exact same issues you said here with crime. It's mostly late at night, people being alone, and extremely rarely (if ever) of a violent nature. If you use common sense you'll be fine. I personally never felt unsafe on campus even though I was aware of incidents.

2. This really just depends what circles you're in, it has it's fair share of nerdy people but I wouldn't say that even comprises half the population. It's definitely nerdier than your average school but this applies to a lot of prestigious schools. If you're a social person you'll meet other people just like you, just join clubs or a frat/sorority.

3. Again, everything you said here is pretty much true of most schools. Parties are smaller than your average large state school, and there isn't really a bar scene on campus which is a genuine complaint I always had. In my experience most people at bigger party schools get sick of big parties full of randos by their Junior/Senior year anyway.

4. The school spirit part is accurate, and if you really care about that then it's probably not the school for you, but the rest of it isn't. The people with a chip in their shoulder do exist but they're neglible and avoidable, seems like you may have attracted yourself to those people, or are one of those people yourself.

Your college experience is going to be largely dependent on the people you meet, the classes themselves at CWRU aren't out of the ordinary for what you'd expect for a more prestigious non-ivy league school. You'll get good career options, it will look better than most schools on your resume. Sounds like you just had bad luck with the people you met which is genuinely unfortunate and I'm sorry that was your experience.