This isn't necessarily a "worst gaming moment" as much as it is a personal gripe, but the fact that your Sparrow (read: fancy hover-motorcycle) is so much more heavily restricted in Destiny 2 as opposed to the original. Full disclosure before anything else: while I don't actively dislike Destiny as a series, it was never really my cup of tea. The gunplay felt good, and the Light abilities were pretty interesting, but ultimately, I just wasn't super into it--both games were purchased at the behest of friends who wanted to play together. Warframe ended up being closer to what I was hoping for, in the end, but that's neither here nor there.
In the original Destiny, your Sparrow had very few limitations--if it could fit within the space you were summoning it, and you weren't in a dark zone, you could summon it and go on with your business. Not so in Destiny 2, despite the dramatically increased map sizes (which, being completely honest, I don't fully believe were actually bigger, but more on that in a second). There are a lot of places in Destiny 2 where the game just arbitrarily decides, "Nope, this is a no-Sparrow zone. Happy hiking!" In addition to that, this doesn't change on repeat playthroughs; despite having experienced the plot in full, at the pace Bungie expected you to experience it, you're not given the luxury of being able to speed between objectives on subsequent runs, making "grinding" (for as much grinding as you can do in that game) feel like even more of a slog. The DLC fares no better, with many of the DLC locations locking access to your Sparrow for the entirety of your time there. This is what leads me to believe the maps aren't actually that much bigger than that of the original Destiny--they just feel bigger because you're forced to traverse them the slow way.
The reason I say I don't fully believe Bungie's hype about the expanded map sizes is because some maps are, very obviously, bigger than what you would encounter in the original Destiny...though not by as much as the hype would lead you to believe. With some of the DLC locations, this is especially egregious because, had you access to your Sparrow, you would very quickly realize the overall space you're traversing isn't that big, and is only made to feel that way due to how you're made to interact with the environment on foot.
The length of this post makes it sound like this all is a bigger deal to me than it really was, or should have been. And a lot of that is, admittedly, just sour grapes from someone who already wasn't that into the game to start with. But the other reason such a seemingly minor thing bugged me is because I'm a big proponent of letting players experience a game at their own pace. Personally, I love lore, I love flavor text, I love exploring, I love a good story--if the game puts it in front of me, and I find it even a little interesting, I'll gladly interact with whatever content it throws my way. But if I've already seen that content before, or if I have no interest in what content is being presented with me, I feel that I shouldn't be forced to engage with that content any more than is strictly necessary. And this doesn't go just for me, but for all players--a game should not demand that it be experienced solely on its own terms. Had you asked a younger, teenaged me what I thought about that, he'd have readily said that I'm just an impatient baby who doesn't respect the vision of the creators, etc etc. But an older me, whose time to play games is already at a premium, feels rather differently.
As a final argument about the pacing (because this already ran on WAY longer, and gotten FAR more wordy than I intended for it to): similar to the Sparrow argument, having to do the "wounded" walk through the opening, even though I already have two other cleared characters on file, was another minor but memorable irritation of that game. I already experienced the "drama" and "intensity", Bungie--let me sprint out of your damn tutorial sequence!