It's a bit like Yume Nikki, in that it sucks if you rate it like a traditional game. Yume Nikki's probably more accessible though, since it has lot less randomness, and as a result, finding new interesting things and depends more on your memory, and less on luck.
Even with all the randomness, I find LSD pretty enjoyable. It was definitely more interesting in the earlier days, when I was coming across new things more frequently, though I'm on day 81 now, and still enjoying it, since I'm still coming across new things. What's worked better to me is to play it in shorter spurts of maybe 2-5 days at a time. I also know that a bunch of the more odd and bizarre textures don't appear until you get further along, so that can help keep things more interesting on later days.