The car itself is more important than the oil as far as its longevity IMO. My '08 Honda 2.4L CR-V now has almost 325,000 miles. I change the oil and filter (Fram or Wix) every 5000 miles. Probably 85% of the time it's some form of Pennzoil, the other 15% has been Valvoline, Castrol or Quaker State. It consumes about 1.5 qts per 5K but still runs and performs like new. It calls for 5W-20 but I've used 0W-20 for several years now. This forum has convinced me that the 0W probably has a better base oil. Plus the other cars actually call for 0W so there's that.
On the other hand, my wife had an '08 Saturn Outlook V6 that I also maintained with the same oil change parameters. At slightly over 100,000 miles, a rod bearing failed and we literally ended up selling the car for junk. It was never a good car and it didn't deserve a new or rebuilt engine. It was better to cut or losses and move on.
So, I think if you have a good car and treat it well, it will last. If you have a crappy car and treat it well, it won't matter.