When I have worked with people in home health where APS was involved they mostly are making sure that appropriate supervision is there, that there is food, heating/cooling, etc. They may offer counseling but I've never seen them mandate it. Mostly they are just making sure the vulnerable party is being taken care of. I have seen them push for nursing home placement but even then in the case I'm thinking about they left it as "either you need to have 24 hour care in the house by tomorrow or you will need to work with us to find a nursing home placement". I vaguely recall one case that I think they did require nursing home placement when there were significant psychiatric issues involved. Other things I remember them doing were providing resources like connection to a charity that gave free air conditioning and then requiring it to be used when a patient was in an unsafely hot home or helping to find adult day care.

I guess what I'm trying to say is at least here APS provides resources more than anything else and when they mandate something it is usually for physical safety.