Big Fedi vs Small Fedi doesn't even have to be a debate, IMO. The federated model can happily accommodate both use cases.

Your instance or local constellation can be as "small" and quaint and well-kept as you want, or as "big" and serious and even commercial as you can afford.

It's absurdly adaptable, just as the Internet itself. Which is, you know, the point.