Lots of butts to clean, but yes, lots and lots of cute/funny comments.
You should definitely read this thread for cute comments: Funny things your patients have said - Nursing for Nurses
And here are some tricks they didn't teach you in CNA class: Things they didn't teach you in CNA class. - Nursing for Nurses
Here's a thread full of rants about the downsides of the job: FED UP CNAS!!!! - Nursing for Nurses
Those are great, useful threads that will give you a feel for what it is like.
My typical day on 2nd shift is something like:
Come in, check each room, get out nightclothes and turn down the beds (unless state's there. Then, don't get out anything early!)
Give my showers. I usually have 3-5 showers to give a day.
Make sure everyone's up for dinner if they've been lying down.
After dinner, aides take our dinner breaks.
Then, clean residents up, put on their nightclothes, and put them to bed.
After that, a last bedcheck (to make sure everyone is dry for the next shift) and then doing my charting/books.
The toughest part is getting all 12-15 residents washed up and in bed between the hours of 7 and 9 so that I actually have time to DO a bedcheck at 9. Of course, all of my residents are total care. Depending on where you work, you may have some fairly independent residents that need less help, and that can really speed up your pace.