I have experienced good tests and bad tests. I studied in France, tests were open book with no multiple choice questions, only problems to solve. This approach scales badly and is a lot of work for the professor grading but it measures knowledge.
The problems were long, had few questions besides describing the problem and maybe a few questions to guide the student along the path to solving it. We had either 3 or 4 hours to solve those problems.
Those tests worked very well. I'd come out from one of those tests having often learned something new.
I was an exchange student in the US, tests involved multiple choice questions, they were closed books with questions around rote memory. While I did feel that some of the education in the US was valuable and interesting, I hated those tests, they didn't correlate as much with comprehension of the subject matter and more with learning facts that are more or less tangentially related to the subject matter. I still remember in a computer graphics tests being shocked by being asked when Opengl was first released, which companies were involved and other completely useless knowledge.
What's interesting to me is that there's much less opportunities to cheat with the former tests while the later tests are pretty much made for cheating. So, imho cheating is a symptom of bad tests.