Well to be honest it all depends on what shift you are going to be working and what your hospital's policies are. I work 2nd shift on an Oncology/Med Surg unit in a hospital but I did my clinicals in a nursing home. I also had orientation on day shift when I started so I was able to get a good feel for everything before deciding what I liked.
Personally I feel that working in a hospital can lead to more opportunities and is less back breaking than working in a nursing home. During my clinicals I felt like I was fighting an uphill battle dealing with the elderly patients. A majority of them had varying forms of dementia and would act out constantly. Lots of incontinence and trying to get them to bathe was like pulling teeth. Almost all of them required sit-to-stands or Hoyer lifts. It was just exhausting work and I give kudos to all the CNAs who do it because it really isn't for me.
First shift at the hospital was too crazy for me as well. Ok I am a bit biased because I love second shift (hey I like to sleep in!) but I couldn't stand all the doctors, PT, OT, PAs, students, Respiratory, Case Workers, management etc etc being around constantly hogging all the computers so you can't chart or being in a patients room forever and not letting you work around them even if you just wanted to get a pulse ox or a temperature. With middle shift all those people are gone except for the few stragglers so you can work at your own pace and not around theirs.
This is what I am allowed to do at my current job: Vital signs (lots and LOTS of vital signs!), phlebotomy, various specimen collections, EKGs (I don't have to interpret anything. I just do the test and put it in the patients chart.), d/c foleys, 1:1 with patients, blood sugar checks, emptying various tubes, bulbs, pumps, putting patients on oxygen (the RN tells me how many liters to put them on. I can't do that myself). Plus the usual CNA stuff like linen changes, changing briefs and the occasional bath that didn't get done on day shift. I also get to float to other floors after 6 months so you learn a lot in those areas too. One tech just went to the ER for the day and another went to the ICU. So there is a wealth of variety if you like that sort of thing.