Trifle is one I have had in the past and was ok with. When it ran out I had other lube so I didn't bother getting more of it.It is like asking what motorcycle oil is best .
On my road going bikes and every "other people's bikes" I service I use Tri-Flow Superior Lubricant. It is not due to any deep thought or deep scientific reasons, it works good and is easy to buy, but I am not married to it, anything like it will work. MC lube is likely too heavy.
On my off-road bikes I use chain wax/dry lube. There is lots of debate on this but it has always worked well for me (for decades). I do not use it on other people's bikes as I feel they will not keep it up (but I do on my kids MTB bikes as I service them), so I keep it simple with the above Tri-Flow for other people.
I boughtt a huge bottle of rocknroll gold and that is what I have used for almost everything for years.