I find quite a few of them useful. I probably use the copypasto spell more than anything but there are a few others I also use. Copypasto is great for duping fossils to find an expensive one then duping that one over and over to make 2-3k simoleans a day. It's also good for duping potions so I don't have to keep a garden or cauldron after making a batch of excellent potions. I also use the spells to resurect other sims and for the annoying sims there's chillio, zipzap and inferniate :)
I do agree that some could be more useful. Like when traveling through Selvadorada's jungle. You would think inferniate would burn through those vines, but noooo...
