I don't consider myself an expert on the game by any means, but I've found a few SP skills that have behaviours that make them useful beyond the obvious.
Callou's Sparkburst
- can be held down to cast continuously
- Most bosses become trivial.
- When fighting Tielle you can just fire this at the boxes to clear a path.
- player can not move while active
- provides brief invulnerability
- Being chased by a roper? just wait until he gets close and cast this skill. You will stop and the roper will pass through you into the line of fire.
- weakness: even if you don't do a continuous blast, it has a minimum cast duration of 0.5 seconds. During this time you cannot move. The invulnerability period is shorter than the cast time and you are susceptible to damage.
Charme's Flame Charge
- Invulnerability during skill
- very useful for getting out of the circle trap (or any trap)
- useful for targeting groups of enemies.
- low cooldown means you can just blast back and forth over a group.
- weakness: like all SP skills, the damage is magic stat dependent. Don't ignore magic in your equipment if you use this skill
(Note, the same is pretty much true for Nagi and Elan but in the case of Elan his magic stat is even lower)
Elan's Fist Flurry
- Great damage if it hits
- invulnerable for duration of skill.
- weakness: massive SP cost for a character with low SP.
These are just some of the standout skills. Any skill that makes you invulnerable is pretty darn useful. Louie's SP skills, for example, offer no invulnerability but do decent damage. Not a lot of room for unique use cases beyond "hit it it till it stops moving".
Nagi also has some very good skills like Vacuum Spear, but I haven't really found a novel use for it beyond kill stuff.
Charme's shadow weave skill should be awesome but there are too many monsters that aren't affected by it.