Your feelings on Luigi's Mansion 3 are how I feel about Mario Odyssey, ngl. The movement mechanics and stuff are fun, but most of the fun comes from discovering how to get each moon for the first time, at least for me. I haven't replayed it since 100%ing it, 999 moons and all.
Have you seen Luigi's Mansion FPO (First Person Optimized)? Identical game (and GameID, can use the same savefiles) but it has a first person camera and controls like an FPS. There are some control options to sort out, and it feels a little shaky (literally, when luigi's head moves up and down so does your view) but it runs perfectly and overall is very impressive. I'll be playing through using the mod for a fresh experience. Can easily be mapped to keyboard and mouse as well I believe Creator says it should work great in VR but he doesn't have the setup. Imagine having VR 1st person optimized LM