It really has nothing to do with the opening animation, in fact, I’m not even sure if Guake has an animation. It’s about having a self contained terminal “window” where all of your terminals live and you can quickly navigate between them. Then you can hide said window just as fast as it arrived and get back to what you were doing. Keep in mind, these drop down terminals are not treated as traditional windows and are always-on-top.
The problem with traditional terminal windows is: let’s say that I have 4 terminals up for different tasks; it causes a little friction to my workflow when I have to deal with which window is which. That friction is just not present with a drop-down. Of course, you can have a traditional terminal emulator that supports tabs and splitting and set a hotkey to bring the one window into focus with an always-on-top flag; at that point though, you’ve just recreated another drop-down.





I’ll be real with you, it’s just familiarity. Whenever I’m setting up a new system, I just install Guake and throw my config file at it, so it feels the same as all of my other computers.
I’m sure that Yakuake is great and that all drop-down terminals probably have identical feature sets. However, I’m getting too old and impatient to distro/software hop. I just like my stuff to work and as long as it does, I don’t change it.
Concerning DE compatibility though: I run cinnamon on most of my machines and Guake has worked flawlessly for me for years on Cinnamon and Gnome. I’ve never been a fan of KDE though, so your milage may vary.