I think that Purah's later missions are more advanced in almost all aspects - Calendra's Cistern in particular feels like Lampfire Hills Enhanced, but still I like Lampfire for being paradoxically both grim and cozy (even despite at same time being boxy and simplistic). Also I like how - sometimes imaginatively - this mission uses such limited space and features some vertical action.
I know what you mean. Sometimes you just want a simple heist mission and that's all. On the other side, it is often the case that you can guess whether the mission contains something mystical or unnatural, directly from mission title. In my humble opinion, this FM is also the case.