With the more expensive tapes, you get a little better lubrication (so less wear on the record heads), and most people believe fewer drop outs.
Scale it to what you're shooting. If you;re just shooting the dog playing with the hose, use the cheaper tapes. If it's a once in a decade trip to the isalnd of Santorini, get the best tapes possible.
I pretty much use the Sony Digital Master tapes exclusively, at $20 a pop.