The local number variance associated with a spherical sampling window of radius enables a classification of many-particle systems in -dimensional Euclidean space according to the degree to which large-scale density fluctuations are suppressed, resulting in a demarcation between hyperuniform and nonhyperuniform phyla. To more completely characterize density fluctuations, we carry out an extensive study of higher-order moments or cumulants, including the skewness , excess kurtosis , and the corresponding probability distribution function of a large family of models across the first three space dimensions, including both hyperuniform and nonhyperuniform systems with varying degrees of short- and long-range order. To carry out this comprehensive program, we derive new theoretical results that apply to general point processes, and we conduct high-precision numerical studies. Specifically, we derive explicit closed-form integral expressions for and that encode structural information up to three-body and four-body correlation functions, respectively. We also derive rigorous bounds on , , and for general point processes and corresponding exact results for general packings of identical spheres. High-quality simulation data for , , and are generated for each model. We also ascertain the proximity of to the normal distribution via a novel Gaussian “distance” metric . Among all models, the convergence to a central limit theorem (CLT) is generally fastest for the disordered hyperuniform processes in two or higher dimensions such that and for large . The convergence to a CLT is slower for standard nonhyperuniform models and slowest for the “antihyperuniform” model studied here. We prove that one-dimensional hyperuniform systems of class I or any -dimensional lattice cannot obey a CLT. Remarkably, we discover a type of universality in that, for all of our models that obey a CLT, the gamma distribution provides a good approximation to across all dimensions for intermediate to large values of , enabling us to estimate the large- scalings of , , and . For any -dimensional model that “decorrelates” or “correlates” with , we elucidate why increasingly moves toward or away from Gaussian-like behavior, respectively. Our work sheds light on the fundamental importance of higher-order structural information to fully characterize density fluctuations in many-body systems across length scales and dimensions, and thus has broad implications for condensed matter physics, engineering, mathematics, and biology.