Here is another quick exploding barrel, I wanted to create something that was slightly more stylised than fully realistic through flipbooks. I found a tutorial on creating a gunpowder line and so have created my version and implemented it to give a more animated feel. There is a 6D material on the smoke, however it isn't working as planned, so will have to dig into that and create another dedicated post. I may even play around with chaos to get the barrel exploding properly.
Barrel taken from Megascans
Flipbooks rendered in EmberGen
Enjoy
Full Effect
Gunpowder trail
Gunpowder parameters
Player activated