I would not mass-publish templated pages on a small site because programmatic SEO sounds scalable. Scale is easy. Useful is hard.
When it works
Templates earn traffic when each page has a reason to exist:
- unique data per city or product model
- filters people actually search
- compliance or pricing detail that changes by region
Think "plumber in {city}" with real local proof — not "{city}" swapped into fluff.
When it fails
Thin pages with swapped keywords.
Duplicate intros.
No internal path to money.
A small site that publishes five hundred weak URLs often trains Google to ignore the whole domain.
Survival test before you scale
Pick ten template outputs. Read them like a customer.
Would any make you trust the business?
If eight sound interchangeable, stop the pipeline.
Start small and measure index quality
Ship twenty pages. Watch impressions, clicks, and conversions per template type.
Kill losers fast.
Programmatic SEO is a factory. Small sites should run it like a craft workshop first, not a content refinery.