When the Rolling Stones roll into town (NY for me) they play at HUGE venues,the tickets are expensive and you see them on a "Jumbotron "screen;I prefer clubs or smaller venues. Choose the right venue and it can be a grat experience,live music is great!
You won't get trampled, usually there are allocated seats.
You just get lost in the experience. It's great.