Any mission can be an Adventure. If you care about adventure and you care about your safety and your co-workers you make it as safe as possible. If you crave adventure take up skydiving. I got my adventure smelling exhaust on start-up and knowing It was going to be a beautiful day flying. The whole 35+ years was an adventure.
Incidently, Columbia did nite utility work i.e. logging, did for a while but the production wasn't there. Era did nite and IFR utility on the North Slope. As mentioned Sikorsky did hoisting with the first commercial helicopter. We had mobile surgery Pods in Southeast Asia. "Theres nothing new under the Sun", thats in the Bible, the book no one reads.