Good summary, Smerph.
In my experience, anything described as an "erotic thriller" is pretty dire (as described above.)
There are exceptions, like Basic Instinct or Fatal Attraction, though.
My favourite movies with some drama, a good, solid plot and a bit of rumpy-pumpy are:
Body Heat
Don't...