I have 3 cats at home, I can confirm that at least 1/3 dislike the tail touching, as in they will physically recoil from it.
2/3 of them don't care, probably because I've maxed out the respect levels, but if I brush too much they'll just walk away.
But I have to say fluffing a tail is one of the best simple joys in the world.