Programmatic SEO is just noise based on my last 5 years experience
Usually we create pages based on use-case, industry, platform, country, alternative and so on.
For an email marketing company, I would create pages like email marketing for restuarant or email marketing for hotel, email marketing in UK or email marketing in Shopify, MailChimp alternative or MailChimp vs our email software etc.
Whenever we create these kind of pages, within few weeks our impressions, and clicks increases. For one project, I have seen it increased by almost 12k clicks per month.
So if you are focused only on SEO aspects, you would consider this as a success. However if your focus is on qualified lead generation or revenue, then it's a different story.
Most of these programmatic seo pages are top or middle funnel pages. So metrics like CTR and impression would increase but activation metrics like trial or signup isn't that high.
So before pseo if you get 5000 monthly visitors and sign-up percentage was 10% now you will get 10000 visitors but maybe at 6-7%. So overall you would say that you got 150-200 more leads. But here is the twist.
Because you have created so much pseo content with stuffed keywords, your over-all positioning of the product is now altered for 100% of users. So the people don't know whether this product is for them or not because due to pseo, you are practically targeting everyone.
As a result now your sales team will put more effort because of the newer leads but again their conversion rate is low. So if before pseo if the trial to paid is 20%, after pseo it's around 15%. So you are now almost getting the same number of orders but you are putting far more efforts and diluting your positioning and messaging.
Most seo Consultants have less knowledge about marketing wedge and positioning compared to SEO keyword analysis and so they would stuff the pages and thus overall the strategy never work out.
If you truly want to make pseo work out, it would need a lot of planning and not just randomly generating pages as it would hurt more few months down the line.
*Based on my personal experiences and it could be wrong.