I've come across good, bad, indifferent and everything in between, both personally and 'professionally'.
On the whole I think they've got far too much workload and not enough resources to do what most want to do and to do what is needed and take the kicking for that. I feel like I'm in a similar position so I understand to a certain extent.
As a teen I had a positive experience from my social worker, my parents remember it differently because she was there to act in my best interests and listened to me and they found it difficult to come across someone that didn't just take their version of events as gospel as they were used to - and they could be quite hostile to that.
The social worker appointed to deal with my DD because of her father was very good and genuinely imo, supported the best interests of DD at the time - although I didn't agree with some of what she said, I could see that.
I do feel disappointed sometimes with the lack of support in my job, although I understand the reasons for things being slow and clunky, the attitude that I've come across from some social workers professionally has left a lot to be desired, I'm the one dealing with the person who is in the wrong environment when funding decisions or lack of places mean that they don't get the placement they need and I don't have the training to deal with their needs - yet often that's overlooked and the people looking after them get the blame for care needs not met, instead of the real reasons - they're wrongly placed but there's no where else for them to go.
I've also come across some who have no idea what it's like to actually work with people in social care on a day to day basis and refuse to listen and have unrealistic expectations, but I guess they'd say the same about me.
Basically the whole of social care is a shit show, and we need good people inside to change that - and we need them to stay and continue working from the inside to improve it, bit by bit, though I do understand that there's only so much a person can take.
I really hope you do well and find that the rewards outweigh the negatives - best of luck 💐