Hmm, that's actually a fairly good question.
In terms of power relative to their in-game power, that's obviously not the case since if it were, champions like Aurelion Sol (blows up the entire game... and all of Runeterra), Bard (walks through space-time to kill everyone before they existed), or Kindred (everyone just dies) would flat out kill the game. Syndra could 1v9 any human champions etc.
However, their lore sort of extends to their in-game manifestations, either by identity or by kit, some such as Yasuo, Riven, and Jhin have nearly perfectly thematically executed kits since they resonate well with their character, whereas others, such as the likes of Kindred, Kalista, and Karma don't really live up to their promised fantasy when llinked between their color stories and biographies.
Even though most of Yasuo’s wind power seems to emanate from his sword, he is specified to explicitly know a wind technique unlike Riven who has wind powers due to her runic sword. He can create mini-tornadoes, run faster using the wind, create walls of wind for protection, and use the wind to empower his strikes. His fantasy as a wind samurai is fully realised through his kit as he can essentially bend the wind around him to serve his will. His limit is reached when discussing his ability to shape the wind to large distances due to scientific principles of air resistance, as he is essentially limited to a melee range, and his frailty since he pushes his limits with the gentle wind. His weaknesses and strengths meld well together with his thematic. He's also well defined and separated from the rest of the cast, and his interesting gameplay (but the one-sided nature and hand holding mechanics don't meld well into the "skillful" aspect.)