I absolutely agree with the others that your therapist's behavior was extremely inappropriate. I would consider it abusive and manipulative even if he didn't mean any harm. It's definitely possible that this all started out innocently for him - but that doesn't change how wrong it was for him to act like this.

This is in no way your fault. You came there looking for help. It was reasonable for you to expect that you could trust your therapist to focus on helping you and to have your best interests in mind.
He took advantage of you by using the time and money that was supposed to be used to help you to instead make it about him. It was selfish of him to use your time together to get advice from you or make sexual comments for his own gratification when he should have been focused on what would be **helpful** for **you**.

If he needed a friend, he could have looked for a friend in a thousand other places. He didn't have to rely on you, or ask anything of you. A good therapist would have realized he was developed an unhealthy attachment to you and either gotten supervision to help him keep his boundaries intact or would have referred you to someone else if he couldn't resist. It was so very, very wrong for him to encourage you to develop this unhealthy attachment to him.

Even if he is really sick, it's not right for him to look for support in dealing with it from you. He could contact cancer support groups, hospice agencies, or whatever else if he needs more help and support. A good therapist would not want to burden you with his problems like this.