Thankfully the things I love are still alive to some degree so I've never had that moment of thinking something was gone forever and then suddenly feeling the delight of its return. I had some mini Huber moments from the first Persona 5 trailer when it was exactly what I wanted and the FF7 remake even being a thing at all.
A strange one was how I felt during E3 2013 when Sony revealed no-disc DRM, it wasn't mega excitement or anything but it was really significant to me that at a time when I was losing faith in the industry and the people who controlled it that they'd do something like really spoke to me that they understood and respected their customers.
A false dawn was the E3 Square Enix preview video last year where they used Frog's theme from Chrono Trigger as background music. Sadly nothing as come from that yet. :cry: