Macaws aren't typically cuddly. Umbrella cockatoo is a nice cuddly bird(if you can deal with the dander) They are all loud. Some of the conures are sweet and enjoy snuggling. It does depend on the individual bird. If you can finish the handfeeding it will build the bond.
Though many times when birds are in breeding condition they can get aggressive.
I have a 26 yr old Congo Grey and he's really cuddly when he feels secure. I still know he could bite at any time if he feels threatened.