Okay those are nice, but sadly most of them are combat oriented psionic mechanic. Except Prey and System Shock. The recent Fallout PnP stuff added subskill of psionic that are; biokinesis that allow you to be basically Shaper from Geneforge and Electrokinetics that straight turned you to technopath mage.
I know stuff should be more interesting and expanded in huge stash of PnP RPG that i wont have gut to explore. So just need more live demonstration like games. I am looking forward for games that the psionic abilities are more technical/utility oriented.
Tales of Maj'Eyal, I guess? I'm not sure how 'detailed' you would prefer it to be, but Maj'Eyal has an entire metaclass of Psionic, divided into three subclasses. You need to unlock them, first, tho.