Playing with Burning Guns?

I'm looking for a game where the gun effects are cool like e.g. Burning weapons in Assassin's Creed Odyssey. Skyrim, The Witcher etc. All cool games, but I want great weapons.

Best for ps4.

Sacred 2. You could put effects (poison / fire / ice / magic) on the weapons yourself. I don't know if this is available for the Playsi.

Kingdoms of Amalur. At least there were firearms and poison weapons.