The first big "oh my god" moment with film was when I had this amazing location for a shoot lined up, had an assistant with me for the day (my girlfriend, ha! to hold a reflector) and a great model who I always work well with. At the last minute I decided to ditch my 5D Mark II, and ONLY use the Mamiya 645 Pro TL (I have the power winder grip and the metered prism), and only with the 80mm f/1.9 lens. So I grabbed that, and three rolls of 120 film. Portra, PanF+ and another PanF+.
Out of all 45 photos possible, 42 of them were definitely very nice shots that I was very happy with, and like 20 of them were just some of my favorite shots, and a year later, are still some of my favorite shots. It was because I really took my time, like REALLY looked around the view finder, double checked my exposures and focus, I didn't just take a shot, if things looked somewhat "iffy" I would change angles, change positions, get closer, move further back, get her to change her pose, whatever it took. And in the end, if after all that, if it didn't still look really like "WOW!" then I'd just say "there's no photo here", and we'd move on.
It was an eye opening moment for me, and one of the most important moments to date, for me photographically. YES, I did that sort of stuff with digital before, but never, ever, to that level of detail and attention.