This is a good breakdown. A firehose relay takes TB’s of storage and is not practical for self-hosting, and AppView isn’t hostable yet: https://alice.bsky.sh/post/3laega7icmi2q

It’s probably more than you are looking for but if you are already looking at self hosting things connected with NextCloud, use NextCloud Talk. We use it for the family and it is great.