So back to your question: what elementary questions can be addressed using scheme theory? I guess I would say: any question about families, all of arithmetic geometry, any question about varieties over $\mathbb{C}$ you might be interested in over another base, any application of cohomological methods from the analytic theory (e.g. Riemann-Roch) you want to generalize, almost any problem where moduli spaces come up, etc.