Personally, I do not listen to NO for the lyrics, although there are lots of good ones that Barney's done over the years. The lyrics on Movement to me seemed like they were an idea about what Ian would've written were he still there, and those circumstances would dictate that the results would seem forced. I believe Barney has admitted that much in the past, but Movement is the one NO album where I just get lost in the music.
I don't find many of Barney's lyrics embarrassing for the most part, with only a couple of exceptions (RTS, for one), but no one is perfect in that regard. I also glad that he doesn't go for the clever style ala XTC and Squeeze, but the simple and straight forward style of the words helps embellish the intended emotions.
Also, I'm glad that Barney doesn't go for the Mac/Bunnymen approach and overload the song with lots of words. The one thing that sticks in my mind is hearing the Bunnymen's song The Game, and wishing that Ian would shut the hell up and let Will play some guitar.