They're pretty good. They've got a couple of good songs but I'm not a nut about them. That whole psychadelic era of music doesn't really appeal to me that much. Maybe because I don't do acid/shrooms.
I don't think liking psychadellic rock is absolutely necessary to appreciate what they do (well, at least not on their later albums). Some of the guitar solos on Division Bell (particularly on "Keep Talking") have more of a blues influence than anything else. I can understand people not digging their sound, though. I personally enjoy it.