I had a short, 3rd career as a CNA. I worked for awhile in hospital, awhile in nursing homes. Those of us who are familiar with these know that the stats don't tell you a lot. What it always comes down to is the caregiver, on a particular shift, who cares for whomever you're concerned about. In short, the facility is only as good as the caregiver you have. And that changes all the time. Being a CNA is a physically and emotionally tough job, pays poorly, staffing is usually less than it should be, and turnover is high. We used to lose CNA's to Walmart.
Having both worked in a couple of them, and having been through others with my mom and other inlaws, I think they are all 'hell holes'. It doesn't matter how nice they look (unless they're obviously dirty), or how friendly the intake and admin people are, it's the CNA on the shift and how much time they have to do proper cares that counts. That's a crapshoot.