I think Goffin’s Cockatoo and Rose Breasted Cockatoo’s are a great choice, if you were to prefer to get a smaller Cockatoo.
I have a Rose Breasted Cockatoo, Bubby, he is 9 months old and I adopted him a few months ago. He is absolute sweet heart, very social, friendly, playful and funny.. he loves and adores all the attention he can get and he fluffs his head and stretches his neck out for kisses and scritches all the time. Yes he is loud, but he doesn’t scream a lot, only if he is excited and he is hanging off of something or playing, it lasts only a few minutes anyways. If you are not one to like loud screeching, I wouldn’t recommend a Cockatoo, especially the large ones. (triple as loud as the smaller Cockatoos) Also, you need to take your neighbors into consideration, what if you get a Cockatoo and it screams a lot during the day? The neighbors may complain about it. They need tons of toys (Bubby loves chewing wood) to keep them occupied as well as lots of foraging opportunities and out of cage time and one-on-one time, at least a few hours a day, if not more. Diet is also another big thing, especially with Rose Breasted Cockatoo’s who are prone to fatty tumors, so they need a varied diet with lots of fresh veggies, fruit, and grains, sprouts, pellets (optional) and so on. Do a lot of research before-hand, and I suggest too that you spend time with each Cockatoo specie mentioned, that way you can get to know them, their personalities, and you may be even lucky enough to hear them scream and you will know how loud they are.
With that said, I will post a few videos of my Rose Breasted Cockatoo, Bubby.
(this first video is a video of him screaming, it is as loud as he gets)
YouTube - Bonding
YouTube - Bubby shows off
YouTube - Bubby chases the light
YouTube - Training with Bubby