In which cases Mesh Colliders they should not be used?

beginner, I have doubt.

In every case you can avoid it. more colliders means harder to detect collisions, you can use multiple primitive colliders rather than 1 collider with a lot of edges.