I would definitely recommend his novelization of James Cameron movie The Abyss. Don't be afraid of the word 'novelization' in this case, this book is the perfect standalone adaptation, written while the movie was being filmed and an influence on the film as well.
Having read several of his other books, this one stands out, IMHO, as the best book he has ever written. It combines his skill of characterization with the proviso that things happen. Some of his other works go on and on.
Another plus is that it is a single book, so you are not investing in a series.