DD is 6 and can put herself back to sleep without my help unless she is sick and i need to clean her up. Most 8 and above children can put themselves to sleep and take care of themselves if they wake up. I know a few who would help with their younger siblings at bedtime.
In general no. My kids are 9 and up. They do however have "mom is on the phone radar" which is the perfect time to need something, ask a question, or start picking on each other. This also translates to "mom is taking a bath" and "Mom is pooping." superpowers. But for the most part they do their own thing a good portion of the time, put themselves to bed and get themselves ready for school. We get up with the younger two (9 and 10) to make sure they get ready and such, but they are perfectly capable of doing it themselves. I haven't had to stay by their beds for years.
as for going to sleep my 10 year prefers I'm there (we share a bedroom) but she can go to sleep without me there. she stays asleep all night and if she happens to wake up and have to pee she may or may not ask me to take her. she's still a lil nervous of the dark. As for spending every waking moment- No. In fact she is often doing her own thing and its me asking her to spend more time with me. Conversations will go something like
Me: You know tori, It would be nice if you were home once in a while, maybe watch a movie or play a game with me.
tori: I'm sorry mom, I have a full life, school, friends and afterschool activities. Maybe we can get together in a couple of days.
TMy kids can put themselves to bed but still like to be tucked in. DS is 12 and if he wants that quiet time with me, I will take it! We chat for a few minutes while I rub his back (which I suspect is the real reason for wanting me there!).
My LO is 4, but she doesn't act that way unless she's feeling bad. She can be clingy during the day, but at night we go to her room, read a story or 4, check the nightlights, tuck her in, get our hugs and kisses... and then I leave. She will sometimes wake me up to tell me she's going to the potty, but usually once she's in bed she stays there. It did take a lot of work to get her to that... and we have nightlights EVERYWHERE.
I've always had a bit of trouble sleeping. My mom tucked me in every night until I started college. Until I was 12, about once a week I ended up sleeping in my parents' bedroom floor. After I turned 12, I started getting up and moving to the couch to watch TV until I fell back asleep.
I spent a good chunk of time with my mom when I wasn't at school. I would go to my room and read or watch TV, but I did spend a lot of time with my parents. I had no friends that I talked to outside of school even in high school. I remember going to a waterpark in high school, and my mom told me that if I followed her around all day that I would be in major trouble.
For the record, it is now suspected that I have Asperger's Syndrome so I am sure that my experience is not typical of most children.