Stacking is crazy!

Aha yes I agree! (apart from it can also work well with a tripod - my original example pic was taken with tripod) I think it should always be in mind with any method or technique that they are very rarely good for every situation!  learn something and use it where you find it works best

And the 'downsides' of a technique can always be explored to create interesting effects!

I have to say in situations where moving water is involved or an animal's fur/feathers I personally find it defeats the purpose of improving clarity as you tend to get a weird 'mushy' effect... but as always depends on what you're attempting to capture