Sinking into the ground looked nice. (Until they fall through into the room below) Maybe a little green final fantasy style fade or a spark cloud like Jak and daxter? They look nice in games. Then again, most games now days just have the body's vanish without any effects.
The aliens taking the body away would be cool, but what if they died in the middle of the human base? It would not look right.