Excellent case studies! Just like in your sheet I see Nostr being used as one big database.
As a Drupal developer I’m highly interested in CMSes and I’ve build cross-post modules. I do have a long-term vision to nostrify Drupal which then can be used in a hybrid model (Nostr and a local / private database).
You can find more at https://nostrver.se