Everyone's kind of beating around the bush but what they're saying is that some people in HSC like to imagine that we are very combat-focused and in high demand from spec ops to do real-world stuff. The reality is the Navy currently uses us primarily to do logistics missions and Search and Rescue around the boat. In my opinion this is the best kind of helicopter flying there is.
If you go HSC you will do lots of training flights overland practicing stuff like covert insertion of troops, Close Air Support, Combat SAR, and so on. You will do lots of training missions for SEALs etc. Fastroping, parachute jumps, etc etc. It's often really fun but as with anything that has strict requirements and a grading system behind it, it also has parts that are less fun. The odds of you doing a no-shit combat overland SOF mission in a regular fleet HSC squadron are...slim. You will probably get to shoot one Hellfire in your first tour, at a target in the water most likely.
When you deploy, whether you go to a squadron based on a carrier or an expeditionary detachment based on some flavor of smaller ship, you'll do some really boring flights (i.e. Plane Guard, where you fly around waiting for a jet pilot to eject so you can go save him/her) and some unbelievably awesome flying (i.e. VERTREP, which is the most fun you'll ever have with your dick in your pants).
If you are one of the privileged few to be part of a crew that uses your helo to save someone from certain death, I doubt you'll have any regrets about your chosen path. My Sikorsky Rescue patch is one of my most prized possessions.
Long story short, as far as dynamic, engaging and pure stick-and-rudder flying goes, you can't beat HSC. You'll do a very wide variety of missions, you can save lives, fight wildfires, and really push the limits of the bird doing awesome stuff like VERTREP. Sure, as a community of professionals we don't really have our shit together like HSM, but who really cares. I became a Navy helo pilot to do cool stuff, go cool places and meet cool people. HSC has delivered in spades.