They love it! They like to know you are enjoying yourself. Practice alone during solo sessions and have a little weed or booze before sex to lower inhibitions.
Some noise is good but not too much it can get annoying. I personally don't make any noise unless its like dirty talk or like amazing. Only twice in my life did I moan died some one make me moan
I don't scream but I moan and sigh and curse a lot, a little dirty talk, which still surprises me considering how quiet I am in every other situation. My boyfriend hardly makes me any noise at all except for the occasional groan and exclamation of how good it is, and when I suck him off as he's coming.
I don't think it matters as long as you are enjoying yourself. Really whats hot about sex is how good it feels and the fact that the better it is the less you give a shit what noises you're making, or how you look ect.
I'm pretty quiet, but apparently I have this "sex operator voice" that I use and it drives him insane.