I've been dismissive of the seed oil paranoia and I think using beef fat/saturated fat is stupid, and I still think mostly the same thing, but I was doing a little research, and it seems the one danger with seed oils - really any unsaturated oil - is high heat, which can oxidize the oil and make it potentially toxic.
The worst problem is using the oil over and over again, as oxidation becomes much more severe, so in the case of restaurants using the same batch of oil to fry food all day long, something like beef fat could make more sense, even though the saturated fat isn't desirable, it doesn't oxidize the same way.
But for home cooking, just using the oil one time, especially at reasonable temperatures, the unsaturated oils are superior (except perhaps for taste). Among the unsaturated oils you have a variety of options. Oils high in polyunsaturated fats, oils high in monounsaturated fats, highly refined and processed oils, etc.
Now the higher the poly, the more the oxidation, and the higher the mono, the less the oxidation. So something like an olive oil, or better yet, a high oleic sunflower or safflower oil would be best for high heat cooking.
Refining/processing is interesting, as with some oils it seems to decrease antioxidants, but in others it removes impurities, increases stability, and decreases oxidation.
I'm thinking about just using olive oils or high oleic sunflower/safflower oils.