One type of bird I am growing to love is the rose breasted cockatoo. I had never seen one until a few years ago when we got one in at the sanctuary. His name is Reggie and he is such a sweety. He seemed to really like me and allowed me to pick him up. He says a few words, but is never very loud, doesn't make too much of a mess, and is much smaller than a macaw. They are not the smallest of the cockatoos, more of a medium-small bird I would say. 
We got another rose breasted in recently and he is the same way. Very sweet. Then I saw a few in a bird store and they were also the same way...so I'm thinking they are just generally docile birds. I've never heard either of the two we have scream and their voices sound very much like little robots. Its actually kind of funny.
Before you get a parrot, make sure you research all the different kinds out there. There really are so many that even I have never seen before. Another one we have at the sanctuary is called a citrine cockatoo. She is pretty small and sooo sweet. She is not terribly loud either. 
However, if noise bothers you, one bird I would definitely stay away from are the conures. They can be incredibly sweet birds and I love them to death, but I don't think I could ever personally own one due to the volume of their screaming!