My '72 Tele Custom reissue is such a guitar. Bought it unexpectedly in Turnkey, totally blew me away. Got it back home and couldn't get on with it for gigging - just never had the balls I wanted. Changed the pickups, put on a steel baseplate and brass saddles, upgraded all the pots/caps, had it professionally set up - still couldn't get on with it, though it did sound great at home.
It sat at home from 2005 through till earlier this year as my noodling on the couch guitar. I've now found a recipe with an EQ pedal and an amp where it just has loads of guts to it and sounds perfect for my hardcore punk band.
I had it up for sale quite a few times, but there was just no interest other than people wanting to pay peanuts for it. Glad it never got sold now, its just SO versatile with the P90 neck pickup and Esquire/Broadcaster type bridge pickup.