WordPress Local Service SEO Pages

I want a scalable setup in WordPress that can spin up hundreds (eventually thousands) of programmatic pages, each one targeting a specific local service + location combination. The primary goal is simple: make pages for WordPress that read well for users, but are structured so Google can crawl, index, and rank them with minimal manual input.

Each page will function as a service listing. The focus is strictly on local services, so city, suburb, or neighborhood modifiers must be handled cleanly in URLs, titles, headings, schema, and internal links. Think “{Service} in {City}” pages that automatically pull the right copy, images, and contact details from a central data source.

Core expectations
• WordPress-native solution (custom post type, ACF, CPT UI, or comparable approach—whichever fits best while keeping performance high).
• Dynamic template that inserts service, location, and relevant FAQs into on-page elements and metadata.
• Clean, human-readable URL structure, breadcrumb support, and automatic XML sitemap registration.
• Built-in fields for meta title, description, H1, intro paragraph, and JSON-LD LocalBusiness schema—populated programmatically from the data set.
• Page speed must stay in the green on PageSpeed Insights once the template is live.
• Clear hand-off notes so new services or locations can be added via CSV import or Google Sheet sync without touching code.

Acceptance criteria
1. I can add a new {Service, City} row to the data source, hit “publish,” and see a fully rendered page that passes basic on-page SEO checks (no missing titles, duplicate slugs, or empty schema).
2. Generated pages appear in WordPress search, the XML sitemap, and the site’s main navigation structure (where designated).
3. Lighthouse score 90+ for Performance and 100 for SEO on a sample generated page.

Provide a brief outline of the approach or plugins you would lean on, plus a timeline for a first working template.