The pot of gold that everybody wants is not because people forget to cancel the subscription, but because you don't have to acquire new customers every single day. You can provide a good product to your "fan base" for years.

I can speak only from my experience in the B2C space with a 2 bucks a month product:

It's basically prepaid. Accounts will become inactive when the payment period ends. There is no automatic renewal. The reason is precisely, because I think this is the most transparent way.

It works, it pays me a decent salary and I get to maintain the software for a long time.