Thanks, that's super helpful. Would have loved to have found something like this as a high level flowchart or similar somewhere.

Sometimes a lot of the tradeoffs or design choices behind a tech aren't obvious from the outset.