I started this resource as a way to have a centralised way of updating the answer.  

I then decided to create a Joomla Magazine article with fuller information (and a video).  

https://magazine.joomla.org/all-issues/july-2024/how-to-solve-the-joomla-sorry,-there-was-a-problem-we-could-not-recover-from

I also created a blog on my own website.  As the Joomla Magazine article has an approval process, and decided it was quicker for me to add additional items to my own blog.

You can find my blog here: https://squareballoon.co.uk/blog/tutorials/how-to-solve-the-joomla-sorry-there-was-a-problem-we-could-not-recover-from