I think one of the biggest reasons Stitch is so oft-maligned is that it was adapted from the previous attraction, "Extra-TERRORestrial Alien Encounter" (I may not have the name exactly right, but it was something close to that). Note: "E.T." was nothing like the Universal ride. It was downright SCARY! I, personally liked it, but wouldn't take a child on it. Many people complained that it was too frightening and NOT "Disney" enough.
From a theming standpoint, changing it to Stitch made great sense. They turned it into an attraction that was kid-friendly and featured a Disney character instead of a terrifying (generic) alien creature. In terms of the actual execution of the concept, they were somewhat limited because it was not a ground-up project but a rehab of existing infrastucture. The seats and many of the effects did not actually change.
Stitch is definitely near the bottom of my "To Do" list (I was never that fond of the character, movies, or TV series to begin with), but I don't mind going on if the line is short.
Back to original topic, I remembered that we only went in the "Sounds Dangerous" show once and have not had any real desire to see it again. I do recall kind of liking the original sound effects show (pre-Drew Carey) however.