In terms of performance I recommend this website https://www.vpsbenchmarks.com/ there are other similar and are very helpful, it makes you see visually that the cores and RAM of a provider has nothing to do with others and often some providers with fewer cores and RAM are faster than others who have more cores and RAM, so be careful with marketing ...
UpCloud, Vultr, Genesis and Kamatera are very good options in Europe, anyway regarding the location you should not have problems especially if you want it in Central Europe, virtually all providers have servers in Europe and leave it to your choice when you go to create the server, just check the locations of the provider.
About the active users and the technical specifications suitable for them is complicated as everyone says around here can depend a lot on the extensions installed.
