Power to possess ultimate power, with certain limitations. Lesser version of Omnipotence.
Edge of Omnipotence
The user wields almost supreme power, but they are have some form of limitation/weakness that limits their power and prevents them from gaining true omnipotence. They may be absolute on specific fields and not others or may simply be able to achieve an almost limitless number of effects across all fields with their near-omnipotent skills.
By definition, user is in some ways limited. This may be inability to affect something, do something in particular or being limited to certain spatio-temporal/dimensional area or concept/subject, common weaknesses include:
Weak to a certain item, weapon, ability, or concept.
Not being able to alter others' free will.
Other beings with similar/higher level of power.
Users are not Invincible. Compared to True Omnipotence, the user is only virtually impossible to defeat, as they are some certain instances where the user can be defeated.
Enerjak (Archie's Sonic The Hedgehog) was an Echidna demigod whose abilities are derived from use of the Chaos Force and limited only by the imagination of his present avatar.
In the Digital World Phage (Archie's Sonic the Hedgehog) is nearly omnipotent due to all the information she has absorbed.
Mr. Mxyzptlk (DC Comics) pulls universe from his hat.
Dr. Manhattan (DC Comics)
Eclipso (DC Comics)
Captain Atom's (DC Comics) connection to the quantum field enables him to draw upon infinite amounts of energy, allowing him to use it for purposes which are solely limited by his willpower and imagination.
As a member of the Douwd, Kevin Uxbridge (Star Trek: TNG) has the power to wipe out an entire species from existence without any effort, and yet has no power over life as he is unable to revive anyone that has died.
Amara/The Darkness (Supernatural) wields near-infinite power, and could not be destroyed by even the combined might of God and the Archangels, just sealed away.
God/Chuck Shurley (Supernatural) is one of the most powerful beings in the SPN universe, surpassing almost everything else, including the Archangels. Only The Darkness and Death rival his power and might.
Death (Supernatural) is only rivaled by God and The Darkness. He can do virtually anything he wants, and slay anything in creation, from humans to the Archangels with no effort.
The Archangels (Supernatural) were imbued with immense power by God, and are among the most powerful beings in the Supernatural universe, being able to achieve virtually anything with Reality Warping. They can overpower and kill anything except God,The Darkness and Death.
After absorbing 40 million souls from Purgatory, Castiel (Supernatural) gained nigh omnipotent powers, enabling him to kill Raphael, thousands of angels and unknown amounts of humans without effort. In this state, he is surpassed only by God, Death and possibly Michael and Lucifer.
When Lucifer is on Earth, Jesse Turner's (Supernatural) power is enhanced to a nigh omnipotent level, allowing him to do virtually anything he wants, such as bringing myths to life, exorcize demons with only a word, turn Castiel into a toy and at his very peak, destroy the Host of Heaven.
Jack Kline (Supernatiural), as the son of the Archangel Lucifer, is a Nephillim imbued with near-limitless power, becoming even more powerful than Archangels and capable of such feats such as waking Castiel in The Empty, something that is said to be impossible for even God to do and can even create new angels by transforming human souls.
Genie (Aladdin) possesses virtually unlimited magical power; the only things he can't do are kill anyone and make people fall in love.
Alien X (Ben 10) is capable of altering reality itself with his mind, but is incapable of doing anything unless 2 of his 3 personalities agree to an action.
Reality Gauntlet (Danny Phantom)
Rex Salazar (Generator Rex) as host of the Five Meta-Nanites could virtually do anything he desired.
Bill Cipher (Gravity Falls) with a physical form is so powerful he easily vaporized Time Baby and the Time Police.
Discord (My Little Pony series) is nigh omnipotent.
Chaos (Aladdin) is said to possess more power in his little whisker then a palace full of genies. with the only limitation to his power being that he cannot change things that are predetermined by fate.