New York does have a cool vibe. The intro, with Eno's foghorn synth, really sets the nighttime mood. It's a calm before the storm. And you can't deny the power of Edge's overdubbed guitar attack during the choruses. I think Bono's lyrics, while not genius, are at least effective at times. The first and last verses in particular contain some great lines: "...to drown out the other voices, voices on the...etc." "you can forget, forget how to sit still, tell yourself you will stay in..." "i lost it all to you and your vices" "i hit an icerberg in my life"....the song is really telling a story about some guy who up and left wherever he was from, and tries to find himself in NY. The 2nd verse with the "irsh italians jews hispanics" line kinda kills the mood. Too much of bono trying to say something big about New York, when in actuality the song has more to do with the character than actually being about the city itself.
Wild Honey is a great breezy pop tune that always reminded me of Van Morrison for some reason. I think its a timeless mini-classic. not in the big league of U2 songs, but enjoyable nonetheless.
If i were to pick out songs on ATYCLB that seem kinda just..."there"...i would say WILATW (despite having a killer solo, its filler) and POE (despite having some dark effective lyrics, its the one song that musically comes close to just being flat out 'boring').