What I'm looking to understand is some level of minimum wattage necessary for, say, very slow charging. Or just maintaining current battery level.
Use the charger specified for your Mac model
You can't "manage" the charging rate of your device at the charger level - that's not how it works.
Your Mac and the charger (USB-C PD compliant) will negotiate the current that gets delivered. In short, your Mac asks, the charger responds, and if they agree, power is delivered.
The power consumed by your Mac will vary depending on what it's doing. If it's off or idling, it may not draw much. If you're rendering video, it'll likely draw as much as it can. When you put a lower wattage power adapter in an attempt to manage the charging rate, you're limiting the ability of your Mac to efficiently manage power/performance.
Power is drawn from the charger, not pushed to the device
Would you expect an older 96W charger to be sufficient, for example? What about something even less powerful?
The more wattage the better. Having the ability to draw more current on demand will always be a good thing. When you get a lower wattage charger, once you hit the limit of what it can deliver..well, you hit the limit.
Below are some additional Question/Answer Posts on this topic for further reading.
TL;DR
Get the charger that was specified for your Mac or better yet, one with more wattage. You shouldn't be trying to manage battery health nor performance especially from the charger perspective as the wattage rating will not change what the device needs. Besides, Battery Health Management has been a built-in thing since Catalina.