Non-spellcasters can visit the Magic Realm and observe casters at their doings there. They can pick the magical plants to grow them at home and buy brooms/wands/familiar orbs for their collection (just not use them).
Non-weres can befriend werewolves and ask for Friend of the Pack status. They can read the special werewolf books, but I think they cannot learn the symbols that reveal the deeper lore. Maybe invite a werewolf into your household and have them write a book of their lore for your sim? That would "only" be roleplay, though. Your sim could also study constellations at the telescope, take dna samples as a scientist...
