I actually did use Compiz+Beryll for a fairly long while. Admittedly, the bugs were annoying, but after switching off the most gimmicky bits or at least making them less pronounced (like Wobbly Windows, lol) I found it to be quite nice to use. It felt a bit like if you were using WindowBlinds but supercharged.
I later switched to i3wm and threw away desktop effects though. I wouldn't mind them, but I don't miss them either.