Yeah syncing Matrix HQ used to crash most home servers, probably one of the things that got it on the radar to be fixed ASAP.
Joining a room from server perspective vs syncing the client to the rooms he has already joined
At least a year ago, maybe longer. Syncing with the larger rooms in the Matrix homeserver definitely took its toll on self-hosted servers. Took minutes (at least) and couldn't be canceled.