What is vertical scaling?
There's always a limit on how big you can go, and a smaller limit on how big you should go, but eitherway it's pretty big. I wouldn't go past dual Intel Xeon, because 4P gets crazy expensive; I haven't been involved in systems work on Epyc, 1P might be a sensible limit, but maybe 2P makes sense for some uses.
Overclocking a single-core processor from 2.8Ghz to 4.2Ghz can only take you so far after all...
https://alexpareto.com/scalability/systems/2020/02/03/scalin...