May I rant on your shoulder please?

[Blue]

For me the question of working through something like this or not is a simple one. Will you ever be able to fully trust him again regardless of your relationship status? There's your answer. I don't know how you will answer that question, but were it me, that would be the one that answered all the rest for me.

It's your call, I know what I would do and, that's give him a time limit for getting out of my house. Depending on a lot of factors, I'd decide if it was fair to give him some sort of voluntary separation settlement in the form of money or a vehicle or, simply to give him time to get his crap together and get out. That's me though and you know what's best for you at this point.

Whatever you do, it's time to take care of you and not worry too much about him or anyone else right now. Do what you need to do for yourself.