The way I look at it is that the manufacturer recommends an oil which includes an API service class and a grade (viscosity). Oils marked that meet that specification will work fine.
Not all oils will meet or exceed these specs. Some oils are not made for automotive use (airplane engine oil for example) and not all oils will have the correct viscosity. Oils that don't meet the specs can and HAVE caused engine failures.
We pretty much know that the popular synthetic oils can exceed the capabilities of the recommended dino oil. The question is, do the improved performance characteristics help us in any way? Perhaps you believe that Mobil-1 is better because its viscosity break down point is 300F (or whatever). What if some other oil was 400F... would that be even better? Put another way, what is the highest temp the oil ever sees? Does getting oil that works above that temperature help? Honda says 10w30 dino oil is good enough and I don't have any evidence that the oil ever sees temps above its range.
Many people want "a little better". Practically speaking, I'm not sure there is any evidence that higher rated oils improve engine performance or reliability, even in extreme use cases. (Note that reducing viscosity is not "higher rated".)
All this "oil X works great" stuff is just opinion but not based on any analysis. Sure, "oil x" didn't break stuff but neither does dino oil.
Don't take this the wrong way. All I'm saying is that you can sleep well at night with the recommended conventional oil as I don't believe there are any (stock engine) use cases where that oil isn't sufficient. If there was, Honda would change either the engine oil system or the oil recommendation.