Yeah this moment is great and it's a lot of fun seeing people's enthusiastic reaction to seeing it happen for the first time. The build up makes it so earned in the film.
I'm personally not the type to clap and cheer at a film and I see all these Marvel films opening day and multiple times while in theaters. My first reaction is filled with some laughing and gasps and what not, but that's usually about the extent of it for me. If others have a reaction to movies, I welcome it, regardless of what it is. Even in a movie I'm not on the same page as other people, just to see a film illicit a genuine reaction is a great part of a film going experience for me in the theaters.
I don't like people talking throughout a movie (although in the right context it could be fine, I personally like talking shit watching a movie with some friends at home), but I think there is difference between that and people just emoting in reaction to what they are seeing, since the latter is what a filmmaker hopes to illicit, regardless if they are feeling it internally or yelling out loud in reaction to what is happening.
Some people really sound miserable if they think any kind of reactions shouldn't happen in a theater at all.