It likely depends instance to instance due to how Lemmy is federated. You may want to try browsing some small communities that you enjoy and seeing if they want an extra mod.

I imagine a lot of the time they don’t feel the need to actively looking for one just yet but if the community sees a surge in people that might change in a hurry

I haven’t come across a general community for it though to answer your question