If you’re training for the sake of training, any set intensifier is fun in the sense it makes it more challenging. Not sure if it does much to help muscular growth for the average joe, it may even be detrimental, if they’re natural.
For bodybuilders in the pursuit of size, I think set intensifiers are crucial. Anecdotally, I’ve seen a difference in my and my training partners physiques when incorporating intensifiers. Surprisingly, this method of training (drop sets, giant sets, static holds, etc) helped my legs and shoulders grow the most. Whereas, straight heavy sets is what helped chest/back to grow.
Long winded response to it has its time and place