I think the ideal situation would be, if the RH tyres would last about as long as a full load of fuel does. It would be nice actually only needing to pit when the fuel runs out. That could be about 45-60 minutes or so.
Now, from that we could try to derive how long the other 2 tyre compounds should last in order for different pit strategies to be possible. If we assume that the Racing Medium is about 1 second faster per minute of racing, then that would amount to a 45-60 second advantage from lap times alone per RH stint, which would have to be balanced against additional time taken for pitstops for the RM tyre. That means there has to be about 1 extra pitstop in that time-frame. Durability for the RM tyre should therefore be about half of the RH tyre. (20-30 minutes)
For the RS tyre, that would mean 2 additional pitstops, if it's 2 seconds faster per minute, and accordingly one third of the RH-lifetime, i.e. 15-20 minutes.
If that's needed, one could also introduce a qualifying tyre additionally, which lasts only 10 minutes or so, but I'm not sure that's such a good idea. RS tyres are sticky enough in my opinion.
Another idea would be to have a Racing Super-Hard tyre for endurance racing, which has only slightly worse performance than the RH, but a lot more durability. I don't know if there's enough of a performance gap between RH and SS for that to make sense though.
And for those that want pit strategy in shorter races, you could introduce an accelerated fuel/tyre consumption, like they have for time in time change courses. That would offer the best of both worlds for everyone.
As it is currently, the tyre consumption sadly takes out fuel strategy almost completely. Of course, you don't need to refuel that much, if you pit a lot more, therefore having shorter pitstops, but for 24 hour races, even if you stay on RH's there's way too many pitstops. Also, the element of deciding when to change tyres in changing weather is almost a no-brainer, because you need to come in a lot anyway, so one more earlier pitstop doesn't make much of a difference anymore.