RAID isn't a backup and should never be considered as such. At most it increases the reliability of a drive (with exception of raid0), but doesn't protect against theft, fire, power surges, filesystem bugs, software bugs, user mistakes and even certain hardware failures.
I would consider raid or raid like filesystem if you had enough music, media, etc that exceeds 4TB.
As for SSDs vs HDDs reliability, one would assume SSDs are more reliable with no moving parts, but there's enough studies done that contradicts that. Tom's Hardware has a graph that shows HDDs and SSDs tend to have roughly the same failure rate the first two years, after that HDDs fail at a faster rate.
And as for sound, only clear advantage for SSDs is that there's no platter spinning up to make noise or vibrations. The data is the same either way, so for a NAS in another room, clearly HDD is the most economically sound choice. (and the pun too

).
Jim