Is Dynamics 365 Business Central really for small and midsize businesses (SMBs)?

Yes. It is designed specifically for SMBs but built on the same enterprise-grade Microsoft cloud platform used by larger organizations.