Is Ultimate Product Catalog only for large catalogs?

No. Smaller catalogs can use it too, but its value becomes more obvious when products need categories, filters, custom fields, product pages, and inquiry paths.