The film you use will make your shooting job easier. I would suggest negative super 8 films in case you have trouble getting good exposures. If you are going to shoot neg you must also have a rank transfer done to get it to video as a positive (easier than it sounds).
The best people to walk you through it would be Spectra Film and Video in N. Hollywood, CA. These guys have not only been working in motion pictire equipment/film business for years, but, they have also done a fair amount of shooting themselves.
I just used these guys myself for a music video and they did a great job for me.
They also carry an assortment of inexpensive serviced cameras, deal in rentals, and discouted packages with film, processing and telecine. They have some demo material in super 8 that they show to walk-in customers.
I second John's comment on Spectra. I had some great experiences there on some recent projects. I use them for both 16mm and super 8 jobs. Great customer service.
I did some work on a music video shot on super 8.
Probably not exactly what you're looking for, because it was purposely done to have a unproduced sort of look. Super 8 shots of the band working on their album in the studio...
I have done several music videos on Super8. I love the format. Some issues you have to worry about is sync. Unless you use a crystal sync camera, time-code slaved slates and playback (which is not cheap) you had better learn to read lips or avoid close ups of singers. I have done DIY transfers, but it is a pain in the ass. Get a good transfer. You are in Mass., look up Brodsky and Treadway. They are the east coast Super 8 gurus.
You can also look into using Pro8mm in Burbank. Go to www.pro8mm.com and check them out. They cut down 35mm emulsions to 8mm size, so you can use Vision2 stocks, and Fuji's Reala and Eterna in Super8. I recently shot a pitch trailer in the format, and the stuff looked gorgeous. I would say stay away from doing anything with under-exposure. About a half to a full stop under your prime exposure I think is the max. The information just gets completely lost in the grain. I played around with an under-exposure technique, and luckily I had a properly exposed version of the take, because the footage looked like bad 800 speed film (and that was on a tiny telecine monitor). U2 has a couple of videos that were shot in 8mm, and I believe that some of Soul Asylum's videos were 8mm. These videos were done essentially by semi-pro filmmakers in Minneapolis, and have the look of a "un-professional" filmmaker. If you do some over-exposure work to tighten up the grain and increase the contrast, you can get some really nice looking stuff out of 8 these days.
Also, pro8 has recently released Max8 - the Super 16mm equivalent in 8mm. That's right, you're actually shooting a wide screen image. Really amazing stuff.