For sure. In fact, I often tell students that if you don’t experience some awe/transcendence or thrill/exhilaration, then research probably isn’t for you (though there’s a lot you can do with science besides being a researcher yourself) because research is often difficult, frustrating, and often very tedious work. Right now I am drowning in DNA sequencing data, which could be a very boring task that is like a cross between data-entry and proofreading, but because of what the sequences actually are, and what they’re revealing, it’s incredibly exciting!