It's not going to happen this way, because these days for you to get somewhere near the top of Google results requires you to be an established content publisher, basically anyone with enough followers.

Someone who publishes content because they love the subject matter would only reach enough of an audience to have an impact if they work on it, a lot, and most people wouldn't do that without some expectation of return on investment, so they'd follow the influencer / commercial publication playbook and end up in the same place as the established players in the space are already.

If you're satisfied of being on the 50th page on the Google results, then that's fine. Nobody will find you though.