Heartbeat - user delete comment from node -> delete also from heartbeat stream
Heartbeat module implemented hook_user_delete() and hook_node_delete() hooks itself. take a look at their implementations.. I think you can implement hook_comment_delete($comment) hook in your module to delete activities from heartbeat_activity table. Here is the documentation.