A generalization of the canonical coherent states of a quantum harmonic oscillator has been performed by requiring the conditions of normalizability, continuity in the label, and resolution of the identity operator with a positive weight function. Relying on this approach, in the present scenario, coherent states are generalized over the canonical or finite dimensional Fock space of the harmonic oscillator. A class of generalized coherent states is determined such that the corresponding distributions of the number of excitations depart from the Poisson statistics according to combinations of stretched exponential decays, power laws, and logarithmic forms. The analysis of the Mandel parameter shows that the generalized coherent states exhibit (non-classical) sub-Poissonian or super-Poissonian statistics of the number of excitations, based on the realization of determined constraints. Mittag-Leffler and Wright generalized coherent states are analyzed as particular cases.