I think I have it somewhere in my house (KotS) - isn't there some sort of prophecy involved, or am I thinking of another low level 4E adventure?
I just wrapped up a long campaign involving a prophecy and I think my players would kill me if I invoked another one right at the start of this campaign.
No prophecy involved. I do second the opinion that KotS is a mindless slog though. Off the top of my head, there are roughly 25 combat encounters and maybe 3 given opportunities to role play. It's mostly a straight up hack and slash your way through waves of kobolds and goblins.