While on the subject of Palminteri, you might also want to check out "The Usual Suspects". It's a little "different", but it's full of twists, and it's a great mystery! Palminteri plays a detective, tracking down one of the most intriquing characters you'll EVER come across (Keyser Soze).
