The first post which came up which a bunch of people asked me to comment on is "Can atproto scale down?" https://bsky.bad-example.com/can-atproto-scale-down/
It's a positive effort, the author is working on testing self-hosting, but the conclusion given at the start is too strong and leaves out the middle