I was toying around with the idea of an Harpy Oracle whose curse was that she could never lift off the ground, despite having healthy wings.
Thus she would be trapped in the mountain temple, forced to rely on the other harpies to bring food and other goods in exchange for prophecies and magical aid.
Earthbound
Earthbound Oracles are cursed to never experience the freedom of flight like their brethren. An otherworldly power tethers their bodies to the ground below.
They can never leave the ground and even the simple act of jumping is a difficult task for them
Prerequisite: Wings, racial fly speed
You can't fly under your own power (even with the help of magic) and you take a -4 penalty on Acrobatics checks to jump.
All magic that attempts to lift you into the air more than a few inches instantly dissipates.
However it is possible for other creatures or objects to lift you off the ground (carried by a flying creature, flying carpet and such). In such a case your body counts as weighing four times your normal amount.
You gain half your oracle level (minimum one) as bonus to your CMD against all maneuvers and effects that move you against your will (such as Bull Rush, Trip, etc..)
At 5th level your wings have become strong enough to create a powerful blast of air. Treat this ability like a Gust of Wind spell except that it does not allow spell resistance. You can use this ability once per day for every 5 levels of oracle you have.
In addition you can use your wings to protect yourself while casting spells. Add a +2 bonus to concentration checks to cast defensively.
At 10th level you can move over any solid surface as if it was flat ground. This ability works similar to the spider climb spell.
Once per day as immediate action you can take root in the ground and gain your full oracle level to CMD for 1 round.
By 15th level you have learned to use your wings to propel you forward. Add half your fly speed to your land speed as long as your wings are free.
Also the bonus to cast defensively increases to +4.