Failure rates for sdd are better than hdd but generally not by a lot. I’ve read that hdds can have a higher “crib death” where new drives have a higher failure rate, but after like a year they are solid. Unless you’re buying thousands of drives you’re unlikely to notice though.
I’ve never heard of “noise” being an issue for an hdd - especially if you have it in any sort of enclosure. If you’re not sitting right next to it you shouldn’t notice.
The biggest differences are performance and cost. If you want speed go ssd. If you want cheap go hdd.
My desktop systems run ssd where performance really matters to me. I get hdds for my file server where I want bulk storage.