Spell ideas for a tabletop RPG

What ruleset will this use? D20? Or something more custom-built? I need to know how magic generally works in your world, as well. Is it something only the elite have, and is used sparingly, or can even a simple street urchin, with training, master the powers of the arcane. Which is more prevalent in your world, mundane, physical damage, or magical ability? Perhaps magical items are something you want to consider. Are they artifacts, or trinkets?

Sounds interesting. Could you give ideas for already decided spell cards to give an idea or do you just want general spell ideas?

in some ways gurps does some of this well you'd just need the well gurps basic set 1 and 2 and gurps magic but that's a minor cost and with the magic styles book and such you could do things also but then if you already have ideas not sure what to say plus getting a new sytem might not work and things but still ^^;; I like gurps

Well, just for the fun of it:

House of "Movement" (bad name but you'll get the picture): Centers around spells of movement like moving faster, being light and as such jumping higher or even flying, teleportation and moving through "parallel dimensions" (similar to the Siren in Borderlands 1). Would not be much of damage potential at first sight, so maybe a House that specialize in avoiding confrontation or trying to use area to advantage.

House of the enforcer: Unlike other houses they can't use their spells to create something new. They just can enforce already existing effects like gravity being stronger. Like a small fire which creates heat just creating more heat. Or if someone has a bleeding wound it could increase the bleeding (would lead to interesting battles). If someone freezes they can increase the freezing feeling. I think with the enforcing and weakening gravity and increasing of bleeding wounds they have some interesting potential.

The Bard type house could have songs which compel people to shake their butts, or thrash about, or do a conga line. It could even require the caster to sing a line, "Come on everybody come and do the conga, you don't have control of yourself any longer!"

Could lead to some creative solutions. Archers on cliff? Play punk rock and half of them hurl themselves off while thrashing about. Or you use punk rock on a bunch of guards and they form a mosh pit and the weakest guard is trampled to death. Or you play the conga song and lead them into another room and try to lock them in. Play jazz to get people tapping their toes, which might not matter unless the toe in question is lying on the drawbridge mechanism!

Illusionist/Psionic: High level 1 time use spell: Bind someone's essence to you. While bound to this person all charm/control/cc spells used against you have a chance to afflict the person you are bound to instead of you. To cast will permanently lower you charisma(or similar stat) by 2 because you take on an evil aura that also effects people's reaction to you. (All good and bad deed reactions are doubled) If the person you are bound to dies you will also lose 1 constitution permanently.

Frost touch: Freezes target for 1-2 turns. If target is hit by anything during frozen status, it dies. Other way, after 1-2 turns target get backs to life losing 10% of hp, but no less than some amount (so weak target could get killed). Spells may be casted upon frozen unit, so it can be buffed/healed.

Boiling Blood: Deals heavily damage to living creatures (considering that you may have undead/golems), makes them suffer for 1 turn, skipping action. Damaged may be reduced for hot-blooded creatures (like demons) or increased for cold-bloodied.

Blood Freeze: Deals low/medium damage to living creatures, makes them suffer for 1 turn, skipping action. Can cause critical damage (up to fatal) - if blood icicles strike the heart.

Blood control: Control target unit for X turns. Optional: If spell is stacked several times, unit can permanently change ownership.

Skin to armor: Transmutes skin to armor, causing pain to unit (deal X damage), reducing max hp and movement range, but greatly increases armor.

Mist: Prevents using ranged attacks or aimed spells (area damage spells will work).

Blinking light: For next 5 turns all enemies will be blind on odd turns (light) and receive increased damage, but they will see on even turns (dark). Can be countered by Light spell, or by the same Blinking light casted on "dark" turn. Of course, if inits are supposed not to have eyes or anything like this, spell won't affect them.

Mana storm: Deals damage to targets in the area, depending on their mana.

Rain: Reduces damage of fire attacks, can (with some chance) spot hidden (invisible/cloaked) units.

Stalker: With some chance makes user invisible until he deals damage. Greatly increases chance to run away.

Brain Death: Instantly kills target

Power of nature: Caster get thick hide (+armor), and sharp claws (melee weapon), but can't cast hard spells or use ranged weapons. Still, he can choose between using melee weapons and his claws. Active spell, also decreases charisma of caster, making it harder to talk with others.

Rage: Increases melee, caster can now attack only with melee, and can't fully control his actions (everyone rolls dice, the highest one gets attacked - even if it's allied).

Speed of light: Very fast unblockable melee attack on enemy, if succeded (roll a dice). If unseccessful, caster misses the target, hits an obstacle and receives some damage.

Tableflip spell - its effects are similar to Armageddon spell in Ultima series :)

Well if no new houses, then just spells -_- :

Bound to me (version 1): The user can bind one person to him which will feel the same emotions as him (for reference or possibly usage you can check Hidan of Naruto of Meldy of Fairy Tail, they have similar abilities

Bound to me (version 2): The user can formulate a rule and a penalty for himself and his target like do not blink or you'll get blind. Spell can differ if only first one will get penalty or penalty for everytime the rule is broken during a specific time. Also you have to decide if the possible penalty increases or decreases with the difficulty of the rule (so much possibilites: do not breath, don't use your left leg, do not use spells, or even active rules, both of us have to call each other's name all 5 minutes .....)

Backstep: The user can send his memories to the past but only for 1-30 seconds which can give him an advantage in actual battles but the farther he goes back the greater are the cost and the greater the risk to create a paradox. Could also have a side effect like increased aging.

Ars Magica has a pretty good list of spells/enemies that you can use as a guideline, as I am sure do most other tabletops. Third Edition PDF Download Link