I used to work in a job which involved working with social workers quite frequently, but I don't think it's relevent at this point in time (over 20 years ago!!)
However, I've had many social workers involved with me and my children over the last 18 years since I decided to adopt (mostly adoption and post adoption but a couple of mental health sw's who work with adolescents). I now have 3 children, and since my elder two have/have had quite significant needs, adoping them has meant accepting continued social work involvement all their childhoods.
So I know what the role of child protection, fostering, adoption and post adoption, and some mental health sw's is - but not had much experience with other kinds of sw so don't really know a lot about it.
I've seen a few brilliant social workers - who had compassion, understanding, listened to me, believed me, fought for what my kids really needed, were creative, kept to deadlines and were very knowledgeable about trauma and adoption issues.
Plenty of good ones - who generally did a good or okay job, had a few issues (usually deadlines, communication and doing what they said they were going to do) but overall listened, put the kids first and tried their best.
Some not very good ones
A few terrible ones
The terrible ones, without fail, had preconcieved false ideas or little real knowledge of trauma. So they tended to - blame me for my children's issues, think I could solve my children issues with different parenting, or believe that short term non-intensive interventions were going to make a difference to my kids. They did NOT listen to me. They had their firm (and frankly wrong) views and they were stuck in those views, and therefore anyone (like me) who said anything which didn't tally with those views...well, we were clearly wrong, and should be talked over, patronised, ignored and blamed.
I have been lied to, and had (important) reports and information about my kids pasts hidden from me.
Oh and the terrible ones think they have to be right 100% of the time, and they twist things round to prove themselves right.
I don't think sw's are very well paid for what they have to work with, especially child protection sw's. Threats, constant hostility, sometimes extremely traumatic stories, terrible cirumstances. Definitely a vocation. No sensible person could possibly think that working with such things is a jolly fun job, or won't affect you on some level