Hey guys,
Compiz reloaded is still very much alive, however you would need to install mate-desktop and I believe cinnamon-destop.
For Mate, compiz reloaded is available and actually is what compiz-fusion was a while ago.
Now, I don't use debian, anylonger but switched to fedora 28 mate. I hope this doesn't offend. I re created a video of compiz reloaded that was done about 11 years ago by Sam Spilsbury on compiz fusion. I used the music from his video.
Sam's original video is here;
https://www.youtube.com/watch?v=epRjN9EkYY4My sad attempt at first time video editing is here;
https://www.youtube.com/watch?v=u1PjjBWgqKESo, compiz is definitely still alive, BUT, the compiz 0.09 series which Sam Spilsbury is now the lead developer of, does not have many of the plugins available.
Compiz reloaded does have all of them, and of course, some are just for "fun".
Sam's video has more of the functionality of compiz, my video was my excitement of compiz return.