I think Broken Bow is the best pilot.
Emissary, while fabulous to me is too whacky and disjointed by the white prophet scenes.
Caretaker is a nice adventure but banjo guy sends it into hokey land.
TNG's pilot is just embarrassing.
Broken Bow looks fantastic (especially in comparison to the other Treks), is a very tightly told story and has a great pace.