A family member has a chronic neurological condition and got pretty sick a couple of years ago. After he was discharged from the hospital he went to a nursing home. This was a decent nursing home, but he was a fall risk who didn't know not to get up. I ended up staying with him nights there and for part of the day. It gave me a whole different perspective on those places. My advice is to do what you can to keep your relative out of there. It may be possible if you get creative. At-home care, family members helping (and taking turns helping), etc. can make this possible. If enough people help with time or money and/or if there are enough benefits available (LTCI, VA or other government disability, etc.) it can become affordable.
There are some good, dedicated people at assisted living places and nursing homes who do a tough job and somehow aren't paid very much. In a major metropolitan area, even the good places were having problems with staffing shortages. It turns out that if an entire generation creates false prosperity for themselves by not having many kids that the piper eventually is paid. Do your research based on current reviews. More expensive or nicer looking does not always equal better. Visit in person. If you notice things like the odor of urine that is a warning flag. I also had a kind nurse recommend visiting unannounced at different hours if a loved one is in one of those places.
There are also bad employees. At the nursing home where I was allowed to stay at night, the employees would yell down the hallway to each other. Old people are also people, and no one would like to try to sleep like that. Hitting the help button for help to go to the bathroom can take 20 minutes or more. It's not what I expected at all.
In the hospital (a very good hospital) some of the employees were mocking a patient who was delusional. I recounted this story to a caregiver who said that she visited her mother in a hospital. Her mother had a skin condition and was crying when she got there. She asked her why she was crying and she told her that the nurses had been making fun of her peeling skin. There are some bad, uncaring people out there. You have to be your relative's own advocate. God be with you!
p.s. Yes, you will be appalled at how much everything costs.