My favorite is also It. I cried huge tears when it was over.
The Tommyknockers and The Shining tie for second.
I love short stories/novellas: The Mist and The Body (Stand By Me)
Newer ones I really liked- 11/22/63 and The Institute
Like you, I loved The Stand but I agree- it fizzled.