Yes, it is possible to make enemies explode in a splash of gore much alike to the Daemon's spell. Animation is pretty much the same. Some flying ribs, some blood splatter and the splattering sound.
You may also reproduce this effect directly on yourself via various cheating tools such as Cheat Engine, for an example, by editing/altering your HP pool. Your character will simply continually explode on spot, constantly producing more ribs/blood/gore.
To Achieve this on enemies you really need to be doing far more damage than the enemy has HP, so that it is, in a way, an overkill. You don't need to critically hit, either. A regular hit that's powerful enough will trigger the animation sequence which overlaps the dying animation sequences. It is important, however, to have a high physical hit damage and Gore enabled in one of the .cfg's
Unfortunately, the spell animation for tentacles of the Daemon are very glitchy and might break a game leading to an error and a CTD if a lot of enemies are hit on-spot. In the best case scenario it will just make the game have FPS dropped to about 15FPS. Even though the spell is extremely powerful, that's the only reason why I do not use it.