One idea could be that while holding up the sky, Percy has visions of the past and future of the gods' reign. He sees how the sky -holding task has been a crucial part of the power balance in the mythological world. Another plot could involve Percy communicating with the sky itself, as if it were a sentient being, and learning secrets about the cosmos that no one else knows.
Well, a great plot for a 'Percy Jackson holding up the sky fanfic' might involve Percy communicating with the gods while holding up the sky. Maybe he makes a deal with one of the gods in exchange for some help. Or perhaps he has visions of the future of the demigod world while in this state, and he tries to convey these visions to his friends through some magical means.
One idea could be a quest where Percy and Artemis have to team up to rescue a group of demigods captured by a powerful new enemy. Maybe a Titan who has found a way to drain the powers of young demigods. Percy's skills in water manipulation and combat, combined with Artemis's archery and her connection to the moon, would make for an exciting adventure as they face various challenges along the way.
Maybe it could be a rogue demigod who is jealous of Percy. This demigod could be working with some dark forces and tries to make Percy's situation worse while he's holding up the sky. They could spread rumors among the demigod community to turn others against Percy, making it harder for his friends to get help.
One plot idea could be that Percy has to face Arachne in a battle of wits rather than just a physical fight. Maybe Arachne weaves illusions within her webs that Percy has to break through to reach her. Another could be a scenario where Arachne tries to use Percy to get revenge on the gods by tricking him into stealing an important artifact from Olympus. A third idea is that Percy and Arachne form an unlikely alliance when a greater threat emerges that endangers both of their existences.
A plot could involve Percy accidentally stumbling into Artemis' territory. At first, Artemis is angry but then realizes Percy has information about a threat to her hunters. So they start an adventure to stop this threat. During the journey, they learn more about each other's worlds and develop a mutual respect. Or maybe there's a spell that makes Artemis lose her powers temporarily and Percy has to protect her while she regains them.
A possible plot is Percy being sent on a mission by the gods to study a strange phenomenon in the ocean that is affecting both the mortal and demigod worlds. He uses his scientific skills, which he has developed over time, to analyze the situation. He might encounter sea monsters that are acting oddly due to this phenomenon and has to figure out how to stop it. Or perhaps Percy is recruited by a secret scientific organization within the demigod world that is trying to find a way to bridge the gap between the magic of the gods and modern - day mortal science. He could bring a unique perspective with his experiences as a demigod.
A really interesting plot could be that Cupid, for some reason, decides to make Percy the ultimate symbol of love in the demigod world. Percy is then thrust into a role he doesn't understand, having to deal with love - sick demigods coming to him for advice. Meanwhile, he has his own relationship problems, like his feelings for Annabeth being complicated by this new status. He has to figure out how to handle Cupid's meddling and restore some normalcy to the love lives of those around him.
One idea could be Percy having to adapt his demigod skills to his new situation in a wheelchair. For example, he might have to figure out new ways to fight monsters. Maybe he uses his wheelchair as a weapon somehow, like ramming into foes or using it to block attacks. Another plot could involve his friends helping him adjust, and together they discover new powers or artifacts that are specifically useful to him in his wheelchair - bound state.
One plot idea could be Percy having to team up with Hera to rescue a group of demigods who have been captured by an ancient monster. Hera, despite her usual aloofness, realizes she needs Percy's unique skills.
Another plot could involve Percy getting a vision from Athena about a future threat to the demigod world. But the vision is so cryptic that he has to work closely with Athena to decipher it. Along the way, they build an unexpected bond, different from his usual relationships with other gods. Maybe Percy starts to see Athena not just as a powerful deity but as a mentor figure, and Athena starts to respect Percy's tenacity more than she expected.