One great Loid x Yor fanfic is 'A Spy's Heart'. It delves into the deeper emotions of Loid as he starts to truly care for Yor beyond their fake marriage setup. It shows his internal struggle between his mission and his growing feelings.
I don't know for sure. The ending of such a manga can be quite unpredictable and might not have been revealed yet. You could try discussing it with other fans to get their speculations.