artistically, it's great. it can be minimalist and full of rich tones at the same time. it's often experimental - that is, it's not really intended to be driving music or anything. do you know music history? if not, this is basically what happens:
folk music > choral music in middle ages and renaissance > short chamber music in baroque era > beginnings of opera and longer symphonies in classical era > bigger, more dissonant sounds and ensembles in romantic era > even less regard for consonance in the 20th century and beyond, but at the same time, rock music emerges as modern folk music
folk music is music of the people, not just acoustic guitars and cowboys

So what happens is that as time goes on, people are more willing to explore dissonances in music. Dissonances being chords and intervals which are unpleasing to the ear [the augmented fourth was even banned by the church, being called diabolus in musica, the devil in music, because of its extreme dissonance]. I tend to see music in two "streams" - One being Orchestral > Jazz > Art Rock&Metal/Noise and the other being Folk>Pop Music. Of course, these aren't separate by any means, but they are distinct paths which music has taken.
When looking at the orchestral side of things, music went from being ONLY consonant to slightly dissonant, to pretty fucking dissonant during the romantic era, to so dissonant that only a very small population % will even listen to it in the jazz era, and then upped the harshness of the sound to make the dissonances even more extreme in art metal and noise.
To sum it up, noise probably sounds bad to you because of two reasons:
1. cultural expectation
2. naturally your ear interprets certain frequency ratios as non-conflicting. the basilar membrane [the membrane in your ear on which "hearing cells" live, which vibrates at different spots when different frequencies hit it, just like a guitar string] and auditory meatus [ear canal, which is usually around 3 cm in length and so has certain resonant frequencies which "agree" with it, just like your e string vibrates slightly when you play another e] work together to interpret incoming sounds, and their physical properties lend themselves to certain ratios. the pythagoreans were the first to be credited with postulating this, I believe.
that was kinda rushed, and maybe not what you were looking for >.>