Likely wrong dichotomy:

Yield-generating stablecoins vs. Payment stablecoins.

There will be an infinite number of bespoke, branded stablecoins held at rest for yield generation, but only a few major ones used for inter-stable settlement due to liquidity network effects.

Yield-generating stablecoins are held for earning interest or rewards programs, while payment stablecoins are used for settlement.