Unplugging the MAF sensor, as you discovered, will not immediately give a Check Engine light. When I did it a few weeks ago I drove for about 20 miles with the MAF unplugged, with no light. Then I stopped at a
shop, and when I restarted the light came on straight away. So it has something to do with restarting the engine as well.
I have been discovering recently that the connector itself seems to be crap. Unplugging and replugging it will make the engine much more responsive, and it's even better if I clean the contacts using contact cleaner on a cotton bud. But the effect seems to wear off after a few days - and disturbing the connector again instantly restores power, smoothness and throttle response.
Personally, I no longer believe that there's any evidence the dielectric grease does any good - but unplugging and reconnecting the MAF definitely
does work if you've got a dodgy connection. My strong suspicion is that the people who reported success with the dielectric grease were actually experiencing the benefits of disturbing the connector, rather than any effect of the grease itself.
In fact, the grease that I applied to my connector has gone a nasty yellow-ish brown colour.