When I bought a heatsink once it came with a tube of "Cooler Master" branded paste that was awful. It was chalky, I think using no paste might have been better than using that stuff. Maybe the tube was 100 years old, but I think the Hyper-212 was a pretty fast selling heatsink in 2010, so I'm not sure.
But other than that, every tube of heatsink paste I've ever had seems about the same to me. Including a 99cent tube that I bought at Radio Shack a long time ago. Come to think of it, I liked that (metallic?) tube better than any of the modern plastic tubes or syringes that seem to be the normal packaging style nowadays. I'm currently using a syringe of Arctic Silver Ceramique which is a pain-in-the-finger to squeeze down.
When I first started using paste on my K6-3, it dropped the temperature by 5C versus nothing at all. And that was a thin application - I learned about it's existence from the internet and the internet told me not to goop it on. It helped but it wasn't exactly a revolution. So I've been pretty skeptical about the added value of any of the premium stuff. When it comes to quality, I'm more concerned with how quickly it dries out than any tiny difference in how it performs when fresh.
If I had a bunch of junk packets to get rid of, I'd use them on random builds that I wasn't real concerned about. I have a pretty lax attitude about thermal paste unless it's for a hot running chip in a system that I expect to stay assembled for years.
The most concerning application for me was actually on a car. I was putting paste on an ignition control module which experiences much bigger temperature variations (both hotter and colder) than any CPU. It also would stay assembled for a long time, and I assumed the surfaces might not be as smooth. So durability, endurance and "gap filling" were the big criteria.
I remember seeing some specs somewhere which implied Arctic Silver's more "premium" product (Arctic Silver 5) wasn't as suitable as their cheaper stuff. I think it was because it was inferior on rough surfaces. I don't remember if I saw any specs about temperature ranges. I think I ended up using Ceramique.