I am a RN, BSN. I worked as an Aid/Tech when in school. I worked in hospitals only. I worked on an ICU stepdown floor in a very small hospital, and most of the patients came from the Nursing homes that were associated with it. I learned how to manage and deal with dementia patients here.
When I had enough experience there I went to a MAJOR Teaching Hospital, one of the best in the country, and did a job called Undergraduate Nurse, you had to be in nursing school, and have good grades, and have worked as an Aid. I floated this hospital, and worked everything from Trauma stepdown, to burn, to specialcare nursery, to transplant stepdown, to regular orthopedics. I can tell you that You will work your arse off as an aid, and it is fairly physically taxing. Esp with obesity rates climbing. Most facilities have lifts, and so forth to help save your back now.
It is very rewarding work, esp if you work with a group of nurses that have walked your shoes. They appreciate anything and everything you do to help take the workload off.
I did not work in a nursing home ever, but I do love the elderly and dealing with dementia. It can be very rewarding work.
Hospitals tend to have better benefits, and tuition reimbursement, so that may be something to consider, and a lot of them will hire, and train you.