Here are two big classification results that I'm aware of.
Theorem 1 (Gromov-Lawson). Let $M$ be a compact simply connected manifold of dimension $\geq 5$, which is not a spin. Then $M$ admits a metric of positive scalar curvature.
Theorem 2 (Kazdan-Warner). Every manifold carries a metric of constant negative scalar curvature.