Actually, our YC is the only bird I trust with my granddaughter (and vice versa). Only with me in close attendance, of course. My grand daughter is fearless; but her mother is NOT.
My stepdaughter is purely terrified of birds. She held the YC, too. And I wouldn't have handed her anything with enough of a sense of humor to scare her more than she already is. [She wants to be a vet tech, so wants help getting used to birds.]
My YC is more even-tempered than many Amazon species. The only reason I don't have them hold the Panama is because the Panama is still a little shy & unsure in his new environment. But he is even gentler than the YC.
There are a couple small parrot species who have reputations for being great family birds & it is true of some - but not all - members of the species. I adored my Pionus beyond reason & they've got reputations for being gentle, family birds. But mine hated everyone but me & wouldn't hesitate to bite to defend his territory. Caiques & Senegals remind me of Pionus - many wonderful family birds & a few attack-birds in the mix. And it is awful to get a bird, fall in love & then have to figure out what adjustments you need to make to keep the bird AND keep your friends & family safe.
So my humble opinion - you need to investigate not only species, but the individual parrot who might enter your home. And you might be better off with an adult, with an established personality, than a baby you might raise & love - until it hits puberty & attacks someone.
If there is a good - big - parrot rescue near you, you should investigate what is available. The big birds make their own decisions (and everything bigger than a cockatiel at least THINKS it is a big bird). So maybe you could let the bird pick your family & you humans could learn to adjust to it?
Just a thought. I still wish you the best, whatever your decision. And somewhere on this thread, I noticed Henpecked recommended the cockatiel as the ultimate family bird. I vote with him - but STILL throw the budgie into the ring as an option. Such a big personality in such a little body!