Isolating single unit-cell thin layers from the bulk matrix of layered compounds offers tremendous opportunities to design novel functional electronic materials. However, a comprehensive thickness dependence study is paramount to harness the electronic properties of such atomic foils and their stacking into synthetic heterostructures. Here we show that a dimensional crossover and quantum confinement with reducing thickness result in a striking non-monotonic evolution of the charge density wave transition temperature in VSe2. Our conclusion is drawn from a direct derivation of the local order parameter and transition temperature from the real space charge modulation amplitude imaged by scanning tunnelling microscopy. This study lifts the disagreement of previous independent transport measurements. We find that thickness can be a non-trivial tuning parameter and demonstrate the importance of considering a finite thickness range to accurately characterize its influence.