I have to like and feel liked in therapy. At least that has been the case for me so far.
But I don't think it's necessary for everyone. Some people enjoy more confrontation or a sense that they are "working" and don't want or need warmth. Depends on your personality and your needs.

I have had a few different T's whom I consider to have been good and they were quite dissimilar from one another in their approaches and in the feeling that was in the room when I was with them. There are many ways to be helpful.