The Big Let-Down for me was Stonehaven pipe tobacco.

It was expensive and VERY hard to find, but everyone was singing it's praises for years, so I had to try it. What a let-down. It had a distinct metallic tang to it and some strange chemical taste in the background. I'd rather smoke Prince Albert.