Not sure if it counts as a pilot per se, but the first episode of Fargo is awesome. Not just for what happens (a lot) but for how glorious and seamless the transformations of Billy Bob Thornton and Martin Freeman are into their characters.