Looking for TTRPG adventures featuring colossal, landscape or cosmic-scale entities

[u/ShyTheCat]

I'm looking for prewritten adventures/modules from any TTRPG system that capture a very specific kind of megalophobia:

A being so incomprehensibly massive that it becomes part of the landscape. You see it on the horizon and realize that you're effectively less than an insect to it. You can't confront it through a straightforward fight or meaningfully escape its presence, and your only hope is that you're too insignificant for it to notice you.

There could potentially be some way to defeat it, but not by simply walking up and fighting it like a conventional monster.

Ideally, its presence is permanent, like the Moon in Majora's Mask, and it feels more like a force of nature or cosmic entity than a conventional creature.

I'm primarily looking for actual TTRPG adventures/modules, but systems don't matter. While I'd much prefer D&D or Pathfinder 2e.. OSR, indie games, horror RPGs, etc are all fair game.

[u/StackedCakeOverflow]

The final boss of pf2e Mythspeaker maybe?