I actually quite liked Skyward Sword's soundtrack. While it's true not a lot of the tunes were overly memorable, they honestly don't need to be imo. As long as they fit. And the tracks in SS fit extremely well with the areas/people they represented. The Faron Woods theme fit the atmosphere of the area really well, it actually sounds like a tune you'd hear while walking through a cheery lit up forest (which Faron Woods is in that game). The Skyview Temple theme is grand and gives a sense of despair, which you genuinely feel while walking through that partially ruined, undeniably eerie place. It's one of the best dungeon themes in the series imo. The track that plays while flying through the sky is very Super Mario Galaxy-esque, and you really get that sense of flying through the sky. Plus Ghirahim's theme is awesome, Fi's theme is great, and can you imagine playing the epic final battle against Demise without that epic slightly operatic tune playing in the background? Skyward Sword actually has, imo, one of the best soundtracks in the series. Of course, being orchestrated helps a lot too.
So ya, needless to say, I wouldn't mind the guy responsible (his name is slipping my mind) to score the latest Zelda game. I'm sure he'd do a great job!
Although, truth be told, my number one choice is and always will be Koji Kondo. Nobody does Zelda soundtracks quite like him.
