Perhaps I should just stick to prose over making games?
That’s up to you, but, based on what you have told us, i believe your best bet is with interactive fiction, sometimes also called text adventures. Those are games that put a lot more emphasis on the narrative, rather than visuals, for instance.
The interactive fiction wiki has a list of engines that might help you find a tool you feel comfortable with. Some of these you have already tried, such as Ren'Py or Twine, but there are other well-known engines, like Inform or Ink, that maybe are more geared towards writers rather than programmers. For Ink, itch.io hosted a jam recently that you can browse to see what others can do with it.
If you prefer something more akin to To the Moon, but simpler, you can try Bitsy. Itch.io regularly hosts Bitsy jams, and lots of people have made interesting little stories with it. I do not know if you would enjoy it, however, if you like writing prose.
As for teaming up with others, i can not help you there, unfortunately, because i have never been able to do so.
However, depending on how demanding you are, you can work with free resources available on the Internet. For instance, Aerostar Time Traveler is a narrative game made for a jam that uses exclusively text and sounds in a way that i found very well done, and you can find lots of free sounds on https://freesound.org/. If you are willing to have then text over a static image, like Snatcher or Policenauts did, you might find great resources on https://unsplash.com/ or https://opengameart.org/. You might not find exactly what you are looking for, but good enough is better than nothing.
As a last resort—or as a first, depending on your views—you can try text-to-image models like DALL·E or Stable Diffusion. I have seen people make very good use of these, but it is a bit of a gray area for some.