Believe this... talking to people about engine oil is like talking about religion...
I believe that all major manufacturers make a decent lubricating oil and fuel is so clean today, you can eat off the insides of most engines.
But as long as you asked, I have always liked Quaker State oil. I usually go for a thicker oil than is called for, especially with older cars with high mileage. For example... most cars today are so well built, and the tolerances so close that a good 5W-20 will do the job. Without going into all the chemistry involved, I'll always put in 10W-30 instead, unless the car is still under warranty... in which case I always put in what the manufacturer wants me to put in.
If you live in especially cold climates, 5W-20 will do just fine. If you live in Las Vegas or Phoenix where over 100 degrees is not unusual, I'd certainly go with 10W-40 or even 20W-50 if the car is older.
Now that you are all confused, do what the lube shop says. Put in the brand that they carry.