We have a sun conure, he was attacked by his parents in the nest so one of his wings never grew properly. It's like he is permanently clipped, he can't fly. Because of this we have to be a bit careful of him with our cats, and we haven't socialized him as well as we should (another of my husband telling me he would do something then getting slack). He can be very affectionate, will kiss me on the lip very gently and will snuggle into your shoulder, but he also has a very strong beak and if he bites (usually if we are trying to put him away and he doesn't want to go) it hurts. He also is super noisy, you can't yell in our house as he just starts screaming and you have no hope of hearing the other person. I'm currently at the opposite end of the house and he sounds like he is right next to me. He is a total little character, had a soft toy he adored for some time until he discovered he could pull the stuffing out, eventually destroys every toy that we give him, can open most of the clips you use to attach toys so need to be careful what cage you get, loves his fresh fruit, sprouting seeds when dh isn't being lazy.
We also have two cockatiels - they haven't been hand reared but one of them will sit with dh and is very friendly. They like to whistle and one attempts to talk. In an aviary outside we have a king parrot, a princess parrot, a superb parrot and a kakariki with king quail running in the bottom as well as a pale headed rosella in a separate cage. A kakariki would make a great hand reared inside pet too, he is a little clown of a bird.
We're considering getting one of my in laws Indian ring necks to add in the aviary, they have almost the whole range of colours but unfortunately their violet who was kept inside mostly and they were trying to train escaped from his day cage a few weeks back and hasn't been seen since. They don't seem as exciting as our other birds but I haven't had much to do with them.