Archetypes that add / modifiy / do weird things to spell casting other than spells per day?

[SorrySleeping]

I've been looking at some of the Archetypes on d20pfsrd and I realize they aren't all on there, but I was wondering what archetypes there are for spellcasting classes that drastically change things.

Adding Spell casting to non-spell classes
-Eldritch Scoundrel Rogue gets 6th level wizard list
-Children of Acavna and Amazmen fighter gets 4th level bloodrager (still had how bad this is)

Change Spell List
-Silver Champion Paladin gets his spell list from Apsu's domains
-Enightened Bloodrager adds wizard cantrips and Druid spell list to his spells.

Changing Casting Type
-Ley Line Guardian Witch becomes a spontaneous caster, losing her familiar way of gaining spells too.
-Mindblade Magus and Eldritch Scion magus both make the Magus spontaneous
-Living Grimoire Inquisitor becomes a prepared caster

Changing Casting Stat
-Living Grimoire changes to Int based instead of Wis
-Eldritch Scion goes from Int to Cha
-Sage bloodline (Wildblooded Arcane) Sorcerer becomes an Int based caster
-Empyreal bloodline (Wildblooded Celestial) Sorcerer uses Wis to do everything

[The Sideromancer]

Change spell list:
-Psychic Detective Investigator (6th level psychic)
-Magaambyan initiate (adds [Good] and Druid spells to arcanist)
-Metal and Wood Elemental schools
-Nature priest druid changes aviailible domains
Change casting type:
-Silskworn Occultist Psychic -> arcane
-Id rager Arcane-> Psychic
Change Casting Stat:
-Feyspeaker Druid Wis-> Cha
Removes all spells:
-Warrior of the Holy Light Paladin
-Skirmisher Ranger
-Trapper Ranger
-Untouchable Bloodrager

[Dasrak]

Puppeteer Magus adds the Bard spell list to his class list, and gets class features that make illusion and enchantment good for him.

Unlettered Arcanist gets the Witch spell list instead of the Sorcerer/Wizard spell list.

[Golurkcanfly]

Pact Wizard (HH variant) gets to add Witch Patron spells to their spellbook.