I've got a Yardbird neck in a Thinline Tele. However, I've also got 500k pots, a different cap (0.022, I think) and no cover on the pickup (all Tim's recommendations). I was aiming for typical fat, rounded neck pickup tones, but with extra treble so that with a bit of overdrive I could get that chewy strat thing you hear from Hendrix, SRV or Rory Gallagher. It works better than any strat pickup I've ever heard.
You can increase the treble content by leaving out the traditional Tele neck cover. Changing pots or caps will, of course, affect your bridge pickup too. I think it works brilliantly for my setup because I've got a Piledriver in the bridge. The pot and cap change help me recover some of the treble lost from such a hot, punchy bridge pickup.