The "fun" spells aren't gained automaticially; they must be bought. All abilities that are useful for anything other than fun are obtained automaticially, and then can be upgraded either by buying a version from the store (Apprentice 2), mob-dropped (Adept 1), quested (Apprentice 4, Adept 2, Adept 4) or player-crafted (Apprentice 3, Adept 3).
There's also Master levels, but good luck finding those. Master 1 would be very high-level mob drops, Master 2 Quested off very high-level mobs, Master 3 player-crafted from very high-level mob drops, and Master 4 is an Artifact spell; one per server, given out in GM events.