Here's a little secret for you all: so far in my horror movie viewing, I've not yet seen the original Salem's Lot. I've been meaning to, but it's never happened. What I have seen twice is this 2004 adaptation, starring Rob Lowe (of The West Wing fame). And overall, I am pretty pleased with it.
Many of the characters are enjoyable, and the acting is solid; toward the end, the little vampire-killing group was enjoyable to observe, though I wish they were seen together a few more times than they were. It's a long movie, much like the original (both over two hours, I believe), but I was quite happy with what I saw.
Oh, there's the occasional subplot or scene that didn't do much for me, but those were far outweighed by stuff I enjoyed. Andre Braugher's character, Matt Burke, for example, was a fine character, and not overly likable either. The ending was somewhat reminiscent of Fright Night, where they go to the main house and hope to finish the vampires off, which was sort of fun. I've no major complaints, really, and I feel this is worth a watch, despite the changes they made from King's original novel.