At least he mowed the lawn and you thanked him. That's a good move on your part. Maybe he had something to do or was afraid that you would bring up the relationship and he didn't want to hear it. I do think that if he continues to come around and he sees that you aren't pressuring him in returning home, he may stay longer each time.
I'm sorry your friend spoiled your day. You can always change the subject and not talk about your situation w/this friend.
I do understand how you can become confused by the advice, but each situation is different. If your spouse has stated that you are cold and indifferent, then NC or going dark may not be the way to go. Try something different the next time he contacts you. Ask about his day and appear interested in what he tells you. Mention something that you know that will interest him and share a bit w/him about the children's day. However, you will need to stay away from relationship talks for now.
As for your SIL, take what she says w/a grain of salt. Yes, your h may have said something in passing, but he's unhappy and people will say things that they will later regret. Sometimes people mean well because they want you to move on w/your life and cut your losses, but they aren't walking a mile in your shoes and until they do, their advice is just lip service in my opinion.
Rouky, you are the only one that can decide when it's time to draw the line. I wouldn't make any decisions based on what your SIL told you. Make your decisions when you are calm and feel ready to do so. I, personally, don't think you are ready to draw that line in the sand...but that's my 2 cents.
Sit quietly, the answers will reveal themselves when you least expect them to. The past is gone, the present is a gift and you need to focus on today, allow the future to reveal itself when it is ready.