Hi openminded, welcome to PC. Coming across a person who doesn't have the kind of honesty and values you have can be very upsetting, upsetting because you happen to be a nice guy. The reason you continue to think about this experience is because you need to actually learn from it so you don't put yourself in this position again. You are like the kind hearted woman that went for a walk in the freezing cold and came across a frozen snake and felt sorry for it and brought it into her home to save it. Unfortunately the snake came back to life and bit her and it happened to be a poisenous snake. Honestly, some broken people can be very toxic and they just use you and because you are not like that you will get hurt. In all honesty, toxic people actually seek out people like you too because they know they can trick and take advantage of you.
We are designed to feel hurt so we learn from it and don't end up doing the same thing that ends up leaving us hurt. There are definitely life lessons that can be very painful.