Bookwyrm627: Going without sleeping for a number of game days is probably the problem; after several days of no sleep, your characters are subject to Insanity or possibly Death (in addition to the usual Weakness that hits). An area transition counts for sleeping, whether by stables, boat, or walking, since the game assumes your characters sleep during that period.
muddysneakers: I don't have the ability to last multiple days in Darkmoor, day and half tops, and my characters weren't weak to begin with just insane. But perhaps the underlying hunger is still there even if I cast cure weakness.
By the time you get to Castle Darkmoor, you probably have Town Portal and Lloyd's Beacon. I don't know about you, but I use them frequently to just keep on adventuring, healing the weakness from no sleep whenever it crops up. I periodically get hit with Insanity and Death because I failed to stop and sleep for too long. :)
You don't have to be in Castle Darkmoor itself for days. If you've spent the last three days adventuring in Silver Cove, then Myst, then raiding some dungeon in New Sorpigal, and you might hit the sleepless limit as you then try to clear Castle Darkmoor.
When I talk about area transitions, I mean walking against the edge of the map and getting the choice to spend 5 days (or whatever, depending on your NPCs) to travel to an adjacent area (ex. New Sorpigal to Castle Ironfist).
You can use Cure Weakness each 24 hour cycles whenever it occurs, but the "time spent with no sleep" timer keeps ticking up.