Some great pointers here - I thought I’d replied, sorry!
Not quite your issue but it did highlight a todo which was potentially causing the issue on a site where AddAzureBlobImageSharpCache() was missing - I think this package was split between versions.
Not tried the UsePagedSqlQuery yet - will drip feed the changes to see what works.