If you can't use your spells in every fight, and you're only playing with a wizard, we go right back to snoozefest. A frustrating snoozefest when it comes to some mods apparently.
Whether it's boring or not depends on each person, but we aren't talking about how boring or fun it is, we are talking about the mechanics. You have to competently build your wizard and choose your spells for Swordflight, you can't go in with 4-5 magic missiles and nothing else. I won't say how exactly to do it because it ruins the gripping dungeon delving. It also isn't frustrating at all, you are given all the tools you need to finish it with every class under the sun (shapeshifting druids being the hardest because they suck in general). Just go play it, part 1 is reasonably short, like 4-5 hours, depending on how well you do on the
actual combat. If after that you find NWN to not be engaging then so be it, but that would be
your problem, not the game's.