Welcome to the community!!! And thank you for doing your research BEFORE you bring home any type of parrot...
First of all, Parakeets (Budgies) are a species of Parrot, so you do have a bit of experience with parrots, albeit when you were a kid yourself...Something that you need to realize right up-front about ALL species of Parrots is that there is absolutely NO GUARANTEE that they will talk, that they will be emotionally-connected to you, that they will be cuddly, etc. There are MANY Congo African Greys who don't say a single word during their entire lives. And there are plenty of Macaws that are not at all friendly and that have never bonded-closely with any person. Also, you should NEVER, EVER choose the species of parrot you decide to add to your family based on it's appearance or it's colors. That's a good way to get yourself into a real mess and a possible re-homing situation.
***You ALWAYS want to research the personalities, common behaviors, etc. of each, individual species of Parrot, and THEN ask other owners of that specific species what their experiences have been. And then I would also find a few Avian Rescues near you and go and visit with the birds in-person, because parrots, all parrots, have the intelligence of a 3-4 year-old human child, they use logic and reasoning skills, and they form bonds and develop relationships with others in very much the way that we as people do...So if you are able to spend time visiting Avian Rescues and you allow an individual bird TO CHOOSE YOU instead of the other way around, this is the best way to ensure that you will bring home a bird who will be very-closely bonded and loving with you. And maybe more-so your son, if that is who you'd like the bird to be bonded-closely to...
And that's the other thing you need to be aware of, there is absolutely no way to control/choose what person in your household that the bird will bond-closely with. A lot of parrots choose "their person" to be the one person they give their trust to and bond-closely with, while they just tolerate the rest of the Flock in the house. And you cannot control who that person is going to be, regardless of who feeds the bird, who cleans the bird's cage, who is with the bird all day long, etc., they often still choose the person who wants nothing to do with them. It's a common cause of real issues within marriages, between siblings, etc. And if you decide to bring home a young baby or juvenile parrot from a Breeder or a pet or bird shop, then that will mean that they have not yet gone through puberty, which means that the person in your home they choose to bond closely with may very well change once they go through puberty/sexual maturity, just as their entire personality and behavior may also change when this happens.
****So for these exact reasons, I highly suggest that you adopt an adult bird from an Avian Rescue, and that you take your son to visit with the birds and allow a sexually mature bird to CHOOSE YOUR SON instead of buying a baby/juvenile bird from a breeder or store. And you will know when a bird "chooses" your son, and your son will also know as well...And it probably won't be any of the species you have been talking about, as it won't matter the species but rather the individual bird...
And by "sexually-mature" bird I don't mean and "old" bird...Most species of parrots go through puberty between the ages of 1-3 years old, with some of the largest species like Macaws, Greys, and Cockatoos having this happen between the ages of 5-8 years old. So it won't be an old bird, just a bird who has already gone through puberty and won't go crazy right after your son becomes very bonded/attached to it, because once again, you just cannot force or do much at all to make a parrot bond with anyone specific, they choose who they choose. They are nothing at all like dogs, cats, rodents, reptiles, etc. The only other type of pet that would even be close to what a parrot is like to own would be some type of Primate, like a monkey, lemur, Galago, etc. That's about it...
***One more thing, since you are looking for a companion/a bird to bond with your son, and you want a bird that you know that you'll be able to handle with little issue, and also because your experience with parrots/birds is limited, I would try to avoid some of the more challenging species of parrots there are to own (unless an adult one at a Rescue does in-fact choose your son, then you have to do what you have to do, lol)...I would absolutely NOT consider any of the Cockatoo species, as they are challenging for lifelong parrot owners to take-on, they are very much like human toddlers and they can become very neurotic and demand attention 24/7...And also, you mentioned Macaws "because they are colorful", but once again you don't ever want to choose a parrot based on it's looks, and Macaws can also be very challenging birds to own, especially if you have multiple dogs in the house, etc. Honestly, if you're really looking for a bird that will be loving, who will bond-closely to your son and be a cuddly, friendly, "Velcro" type of bird that always wants to be with you guys, then I'd highly suggest you look into the many species of Conures, as they are well-known as being the cuddly, snuggly parrots who become very attached to their owners and who are not horribly difficult to care for, and who still can live into their 30's and 40's. There are small, medium, and large Conures, and if you go to any Avian Rescue you'll almost always find a bunch of different species of them...But again, the specific species shouldn't really matter, what should matter is that you and your son have visited with the bird multiple times and that the bird chooses your son...