I've owned lovebirds, cockatiels, budgies (english and regular), and now have a little green cheek conure.
I have to agree that cockatiels are a really good choice as far as family birds go. They just have such sweet natures. I loved my Jo-Jo and he was very sweet to everyone. Joey used to sing songs and bow his head and followed me around like a little dog.
That said, I am head over heels in love with my little conure. She is so hilarious and entertaining I just can't imagine my life without her now. She is nippy, but with consistency and working hard she is coming around. She used to bite my husband horrible, now that she knows he gives head scratches she flies to him as soon as he comes to the room and I become chopped liver. She loves to lay on her back in my hand and wants to be the centre of attention always.
She just LOVES attention. LOVES IT. And even though they say conures are not great talkers, I really love hearing her try, and try she does. She also loves when I vacuum. She dances and sings and does the little conure head bang. However, I would probably not have gotten her if I hadn't had experience with smaller birds, she is quite a handful.