I don't know if this is helpful, as I'm not very familiar with Wikidata's infrastructure, but I think that an idea that was discussed in the Wikimedia Strategy 2030 process is charging real money to organizations that consume large amounts of data from the Wikimedia API. By extension, an idea to consider is charging real money to consumers that want use Wikidata services in resource intensive ways. That would have several potential benefits. Charging money for resource intensive requests could make consumers be more value conscious when deciding which queries to run, it would probably reduce the workload on WMF's end, the reduced workload on WMF's end could lead to faster performance, and the money could be used for the maintenance and/or upgrade of Wikidata services. I think that offering free services to consumers who are not making resource intensive requests is good, but I am also fine with charging real money for resource intensive requests by consumers. For anyone who wants to make a resource intensive request and is unwilling or unable to pay accordingly, an option is to put them into a "slow lane" where there requests will be fulfilled but at a slower pace than paid resource intensive requests will be fulfilled.