Low-Poly using for 3D Games, where need small number of polygons for real-time calculation.

Middle-Poly using for Animated Movies, they are not sharp like low-poly and not so heavy for animation like high-poly.

High-Poly is typically used for highly detailed static objects, something like statues, detailed furniture, etc...
[hight-poly model source].