All the servers are physically located in the US with the exception of the legendary server Mordor that just opened a few days ago. You need active subscription for that.
For the normal servers marked as EU Laurelin has less players that Evernight but has more serious roleplaying scene if that is something you're interested in. There are also servers for Germans and French.
If you can pay for the subscription I'd strongly suggest hopping in the Mordor server. It's in the 'busiest it gets' phase where there are soo many players having fun at the low levels. I'm loving it. The initial hype will die after few months so now is your best chance.
I have never played Destiny 2 and wanted to try it out one month ago. I asked on Reddit what to do as a free-to-play player to get a good insight of what the game has to offer.
The gatekeeping was unreal. They said unless I'm willing to dedicate hundreds of hours I should not even try and rather uninstall the game immediately. For sure they made it feel that new players are not welcome.
Playerbase toxicity was a harsh reality. The game story, even in the broadest sense, was hard to grasp. The new player experience in-game was miserable. I have no idea what their money making plan is. Live service games need new players to stay healthy.