Is there a difference to what happens after player death depending on it being Just or Heroic? Do they just both send players to a dream bubble or does something different happen?

Nope, it’s just death.