I didn't find Snow Crash to be particularly inspiring but The Diamond Age is absolutely where he peaked for me. After that there's just too much fart-sniffing.
Stephenson's work has a lot of ideas worth wrestling with but as far as crafting a narrative he's weak and fans of his use the former to cover for the latter.
It was out of print for a long time and he sort of had to be convinced to make the book available to read again after large demand.
For me my enjoyment of his books is pretty close to inversely proportional to the amount of weird sex stuff he puts in them. Anathem has none, and I think its one of his best, Snow Crash goes pretty hard, Diamond Age is mostly good but then the end of the book is randomly a weird sex-powered computer thing.
If I'm correctly identifying what you consider "fart-sniffing" in his works, then often those farts are my most favorite bits. The little digressions, the impromptu lessons, the D-plots - love 'em.
For me, Snow Crash was great fun (though also seemed a bit too similar to William Gibson's Neuromancer), Cryptonomicon was an excellent historical novel with some weird "present day" scenes including an ending that made no sense, I couldn't get into Diamond Age, I hated Quicksilver, and Seveneves seemed to be two excellent books written in the same universe by completely different authors who only talked to each about the project for about five minutes.
Cryptonomicon is my personal high point. The Baroque Cycle had set pieces just as good as those in Cryptonomicon, but there were too many characters for me to hold in my head.
[edit]
I didn't read anything Stephenson wrote post Quicksilver since everybody assured me that they were more of the "new" Stephenson than old. However, I see enough people in the comment threads panning README that I might give it a try.
Snow Crash has similar themes to the other works, but its more raw, less polished and kinda less professional than the writing he did later on. Its definitely possible for someone to not really get on with his early stuff, but really like his later stuff (or even vice-versa if you enjoy the less polished style).