Most of the Tom Clancy thrillers are a really good read, note that the sequence of the books is different to the films. Red Storm Rising is kind of a standalone book and a damn good read if you are remotely interested in the hi-tech nature of modern warfare.
James Herbert has written a number of really good books, but I would really recommend Moon for a story that builds up to a nigh on unputdownable finish. Magic Cottage is more whimsicle and less horror, another very good read.
For great endings you really cant go wrong with the Darwin Awards books (sic), usually loads of good endings in those.
Well I wont be as cliche'd as mentioning the Da Vinci Code but by the same author is another book, Angels and Demons, which I personally found to be the best of the books Dan Brown has done.