I've got 16 3.5" hard drives whirring and chugging next to me. I do not miss the sounds. If I could afford the same setup with SSDs I'd do it in a heartbeat. The heat is another story.
My office room is now absent of both noise and heat generated by my desktop and it's so much nicer for it.