Galahs can be very very beaky, nippy, and bratty. Some are sweeter than others, but I wouldn't recommend them for a child to handle.
Kory, I didn't read any of these responses as rude, just blunt. People are telling it like it is, even if it's not what you want to hear.
I think us crazy parrot people would rather discourage someone from even getting a challenging bird in the first place, if it's not a good idea and the bird will eventually end up rehomed.
You COULD end up with a lovely, social, gentle cockatoo that loves kids. It is possible...I've met a few. Probably less likely with a macaw, I think. However, you really have no idea what you're going to get if you just randomly buy a baby. If you're dead set on one of these extremely emotionally challenging companions, I would adopt an adult (that is a few years past sexual maturity) from a rescue. That way you know the bird's personality, and you know it's not likely to change.
Same goes fur cuddliness, and talking ability. Those are traits that are never guaranteed. Even some African greys, which are known to be amazing talkers as a species, may never say a word. Some cockatoos may never be cuddly. Two individuals can be as different as night and day. Again, another reason to go with an adult that is already talking if talking is important to you.
Honestly, I'd recommend a male cockatiel. They are likely to fit most of your criteria, though they are not rare or flashy or large.