The style you describe so well seems to have been inspired largely by the pop stylings of Enya and the later Clannad. In tiny doses and taken for what it is (pop music for a pop audience utterly unfamiliar with trad), it can be enjoyable. Otherwise - Aaaaaaaaaagh!, as you say.

Think twice about buying anything that plays up the word "Celtic" rather than something more specific like "Irish," especially if it also plays up the word "Woman."

I recently watched a TV special by the supergroup Celtic Woman. Plenty of talent, but no relationship to traditional music except for the use of two or three songs in thoroughly pop settings. The network commentators raved about the "real Celtic tradition" presented by the singers and their large back-up orchestra. (Pixie violinist Mairead Nesbitt, of Lord of the Dance fame, was great - as usual - when she played reels with the flair that comes from long Classical training. Actual trad fiddlers don't leap around on tiptoe when they play, however: a minor point.)