I am in my first CS role.
I think it depends which area you're going into, so I can only comment on my experience.
It's very easy to shine in my dept, particularly if you're previously used to deadlines, fast paced work & delivering to a budget. I had 5 'hats' in my old role to fulfil - this one I have 1, that's it. I could do it standing on my head but that makes it hard to feel inspired some days.
It's cumbersome to achieve anything, it all has to be escalated which stops momentum.
There's no appetite to change that - I think some people revel in the endless Teams meetings with no actual deliverables. Again, easy to shine if you're willing to contribute and actually deliver something.
CS look after you very well - every hour you're owed you get, time to volunteer, emergency time off for kids etc. but no private healthcare (because the CS should be ensuring the NHS is fit for purpose), pension is IMO great but many long term employees in the service complain about it. I've been sent on professional training courses in my first few years that I repeatedly asked for in private sector with no joy, so very happy with that.
But I'm here because it's easy, local and I'm not career driven. I get recognition for just turning up and doing what I'm asked to the best of my ability. But I don't love it & really miss the camaraderie and pace of my old work (but not the travel & bullying). I find people in my CS dept are very hierarchical, dry and weirdly siloed (silo'd?) compared to my previous role where we were collaborative & all in it together.
I don't hate it, but I don't rush to recommend it as a place of work. TLDR: I feel like I'm riding a gravy train a bit.
As previous - this is my experience and recollections will differ.