Seeing as how most magick spells are pointless and most weapons/tech schematics are useless, are there any mods that help to fix this problem?

Besides the Dark Magick hack and the rebalanced weapons hack - which are just add-ons - I can't recall hearing of a mod or module that does fix the problem properly.

AWIP made a small start in that direction with adjusted magic and the beefed-up protos from Car-Arcanum, but never really got too far into it.

_________________
If you can't go through a problem, go over it, under it, or around it.

There's the Magick Restoration Pack, which replaces some spells. The first post in that thread is outdated, but more info is available here. I haven't actually tried it, though, as I generally do my own modding.

Tech-wise, I can't think of any offhand. You could grab the Arcanum Weapon Factory to adjust weapons as you like, though. Marvelous little program and quite simple to use.