As you say Motul is one, such as Motul Sport, Millers CFS or their new EE Performance range, Fuchs Pro S, Gulf Competition to name a few. These are performance/track/race oils but are fine for road use and many more than you may think run them daily.
Then there are premium quality oils that are fine for some track use, Mobil, Castrol, Shell and many many more.
The point I am trying to make here is the Tesco own brand thing, and the difference you will find between that and a premium or track/race spec oil. They are night and day. One is toll blended to the lowest cost for Tesco, the others are premium quality oils and that is reflected in their performance on and off track. Like everything in life, you can buy quality or you can buy crap, but is important to know the differences between the two. Tesco's own 5w-40 and Castrol Edge Titanium 5w-40 are very different animals from one another.
You said it yourself, you would not use it in a fun car although you have no logic for that. I would argue you do have logic, or you wouldn't think twice about it. The answer to your logic is, Tesco own brand is not built to the quality you want on track, would you trust it? As I said in ealier posts its all about how the oil can cope with it, and shearing down under hard use on track. Shearing means the oil is thinng, breaking down, you don't want that on track. The engine will not thank you for it.
Cheers
Guy