I was a TA for the fundies class, as well as a CS minor. I agree that people are pretty down to earth and much more collaborative than competitive.
The difficulty of courses can vary a lot from course to course, who the professor is, and what your own strengths and weaknesses are. The same goes for courseload. Overall, expect to be challenged but not overwhelmed, as long as you stay on top of your work. (i.e., when you have a major programming homework for the week, don’t wait until the night before to start it.) Most of my courses emphasized homework projects much more than tests, but this can vary by course (expect less of this from more theory-related courses). My last two CS courses (robotics and artificial intelligence) actually had no exams and were entirely graded on weekly homework, a few online quizzes, and a final project. I know a lot of people who work on side projects, and there are great people in the NU Hacks group, which meets weekly to code on their own project together.
From my experience, professors are always very responsive to requests for help or feedback, and willing to find time to meet if their office hours don’t work for you. For the introductory classes (fundies 1 and 2), there is a huge team of tutors and TAs to help with the course, so getting help shouldn’t be a problem at this stage, if you take advantage of it. (Bonus tip: come to office hours sometime besides the day before the homework is due and you might have a TA all to yourself to help you out.)
The facilities are really nice - the whole department is located in West Village H, which is one of the newer buildings on campus. The computer lab is plenty big, with Linux and Windows computers, and it’s accessible only to CS students, so it doesn’t get as crowded as the library computers. There are also nice sunny study areas in the building that I’ve used to work on group projects.
Northeastern has a big boost when it comes to the job search because of co-op - and CS is one of the better majors for co-ops. They pay well, they’re plentiful, and they’re at some top notch places. This also means that big companies know Northeastern students are well prepared for CS jobs and many recruit heavily on campus. I have friends who are recent CS graduates who now work for Google, Amazon, IBM, HubSpot, and a lot of great start ups.