I've heard many a story about professors treating it like a trap door, paying no attention to prevention and much more to detection/punishment to the point you'd think they're sadistic pleasure out of it. (I doubt they are, but you'd have to numb yourself to it in that position.) In certain ways, I guess this is better than pushing people through to the next class—giving them no option but to catch up quickly or cheat more—but it isn't great...
OP mostly talks about detection/punishment, but I think it's also the job of course staff to make cheating as impossible as possible before it happens. Engaging and novel assignments are great; putting more weight on exams is low-cost and acceptable.
There are flaws in every method of measuring competency but I thought this was one of the better ones, and it is very difficult to cheat on. His exams were by far the least grumbled about and I don’t recall a single student that thought the method was unfair. And even though this required more upfront work from the professor he said it was ultimately less time consuming than grading written exams, and far more enjoyable.
I do like the idea, though. My parents from the former Soviet Union had oral examinations for their entire schooling.
What I think teachers could do is to come up with truly novel and strange assignments that require real curiosity and creativity (and some do, which is great). I can only assume this to get harder and harder with modern AI readily available to everyone but perhaps the key is to assign something that would take a long time even with these tools. It should be as hard as necessary which is only all the more fulfilling to a curious student.