It's all relative depending on where you're deployed and which community for helos. There's no doubt that the TacAir guys had put more ordnance on target than any other Navy asset, so I'm not trying to argue that point, but some helo communities have more or less likelyhood to actually shoot than others.
Ironically, among HSL, guys doing CD Ops shoot more (from a crew served weapon, anyway) than guys in the middle of OIF. A frustrating statistic. Historically, HC/HSC doesn't do much w/ shooting because they don't have much to shoot with (yes, I know they did shoot, it's not a slam, just not their primary mission). Obviously that's changing w/ the upgrades and the Sierra. Then there's HS, which tends to do more overland missions now (w/out a big red cross on them), so it could be said they have the most opportunity to shoot, but I don't know if that's actually true.
As for "what's good about helos," the biggest thing is that they're a blast to fly. Better than a jet? Maybe. Personally I'd rather fly helos. I think flying Jets would be a lot of fun, but I don't really have a desire to fight a jet. Also, the missions for helos can be varied, which makes it more interesting to me. ASW today, SSC tomorrow. Gunnex next week.
I'd keep asking questions here to help refine your incoming info.
