Looking for an advice to how to achieve this Diablo style effect

You can’t do transparency by post processing. You need to swap the material to a transparent one when the player is behind the mesh.