Do you guys think I should be dancing while the song is playing to get noticed by the band?
I think you'll just get laughed at, probably. And I doubt the band will notice a production assistant based on his dancing talent as opposed to.....well, literally anything else you do.
As everyone has said, it's a foot in the door. A job is a job, and even unpaid PA work is better than none. You'll get to see how music video shoots (and by extension, all filmed media in general) works, as well as get used to the workload and the flow of things. The first job I ever took in the film industry was an extra in two crowd scenes for
Renee. Trust me when I say that being one in a crowd of thousands is a much lesser position in all respects than a PA; unless you have some kind of extraordinary look or talent that can be immediately recognized or they happen to put you right by the actors and in focus, you're likely nothing but space filler. At least as a PA you get to be in the thick of it and potentially helping with important tasks; it's not all fetching coffee and passing out clipboards.
On at least one TV production, in fact, the PAs were treated as just as much a part of the crew as the Director of Photography and boom operator. They made lasting connections with the cast and crew, even the extras, and likely guaranteed themselves extra work. Depending on how you play your cards, taking a job as a PA can be your stepping stone to gradually improved positions. Not to mention that getting crew jobs is often WAY easier than getting acting jobs, so you're more likely to have plenty of work.
On the note of the job being "fun", it depends on the production. A big Hollywood thing will probably be a hectic experience with a lot of people doing a lot of tasks and you'll end up sticking with your immediate coworkers, but the aforementioned TV production had a very familial atmosphere where everyone knew everyone (it helped that almost the entire crew had worked on a film earlier in the year) and readily welcomed friendly, hard workers into the fold. I was a paid extra and not under contract for X number of days (meaning I only came in when they wanted me AND I wanted to come), but the atmosphere was good enough that I spent 16 or 17 days working and made over two dozen new friends and acquaintances all over the business. Because it was being filmed on the Universal Studios backlot, they even had a group outing to Halloween Horror Nights (I was a scareactor this year, so they got to see me several times as well). If you can get on a production like that, you're set.
But never, ever consider any job in the film industry to be a "bad job." There's bad jobs to take, certainly, but there is no single career that is worse or less important than any other. Filmmaking in all scenarios is a team effort, and going into a job actively viewing yourself as the bottom rung or thinking that you're nothing but a nameless gofer is no way to start a career.