Pros
IF you get a good manager, you can feel fulfilled (to a certain point) by your work and your team, even the students you support (if you do that). There are a lot of initiatives in the works right now for diversity, equity and inclusion, as well as bettering the campus climate.
Cons
IF you get a bad manager, work is grueling, faculty microaggress or bully you without consequence, and you feel isolated and unsupported or not valued. On top of which you are NOT properly compensated for your work and dedication, or growing expertise. You have to make sure to do the work with your union to put your managers in their place when they step out of line (again, usually without any real consequence) and if you want to get higher degrees and better professional development, the only way to be recognized in pay is to leave the job you put time and effort into learning, for another job somewhere else on campus that pays more and is a higher level. Good benefits BECAUSE of the unions!