Final Fantasy X after the epic start you wake up on a beach too if I remember :), after that the pace and tone are pretty slow. Opening with a big set piece is considered good storytelling because it sells your story early, and will get people invested.
I think when people talk about big bombastic storytelling as being bad there really talking about a story that doesn't have any breaks in its pacing or tone, all climax and no tension. For BG3 people have complained about how there is a lot of tension from the opening, because of the tadpole, but the story doesn't follow that tension, or at the very least doesn't connect well a lot of the sidequests with it.