We have both indoor and outdoor cockatiels, most of which I hand reared. We have 2 particularly special boys inside.
Lemmy is our son's bird and he is the most patient bird. Our son is very lively, but he is Lemmy's favourite person despite the fact our DS is loud and doesn't sit still.
View attachment 2433036
Then there's our little Sprout who had my heart from the time he came to us at 2 weeks old. Sprout thinks the world is for his convenience and though he is a little bird (his parents were feeding his much older sibling and neglecting him) he has so much attitude. He's fully aware of how cute he is so he gets away with a lot. He's a real chatterbox and knows how to get our attention. He loves our daughter and will tell her off for scritching Lemmy instead of him.
View attachment 2433039
If they were outside they wouldn't get the attention they think they deserve.
Every single cockatiel is a completely unique character. A hobby breeder for whichever bird you choose would be best if possible as they could advise you on the birds personality. Hand reared birds are more expensive but a young parent raised bird who has been handled a lot would make an awesome pet too.
Lovebirds are beautiful but you'd need to get a hand reared one to have a tame one, and they are best in pairs. They make a very sharp call which I don't like. My sister had a pair when we were kids and we had to swap the male for another one as the female wasn't letting him eat and was attacking him. They need a good sized cage as well.
Male budgies do chatter all day which I find annoying (but other people don't). They really should be in a decent sized cage as well as they are active birds.
Cockatiels have times when they are active and noisy morning and late afternoon but they also spend a lot of time snoozing and preening.