So is the case then that lemmy instances dedicated purely to hosting user accounts not really big communities with much traction outside of their local instance actually makes a lot of sense?

Distribute the client-server load as much as possible while leaving the community hosting and coordination to bigger more central instances (which also helps with discovering communities)?