In the case of Pittsburgh tools, I think the cost is pretty much in line with whatever dropshipped options but you know exactly what you're getting. With the other lines at HF you're paying more but getting something that's usually much higher quality. Also you can't put a price on getting asked "would you like a free bucket?"
I'll probably end up cancelling my membership at one point in the future because I won't have the need for tools as frequently, but I tend to go at least once every couple of months since I work on my cars and fix stuff around my old house.