Well, we have defeated the Hill Giants and are going on to the Frost Giants next. One of the players is running CoS to give our normal DM a break.
How boring is it? Not at all. But, that being said
SO MUCH of that depends a lot on the DM and table's style. If someone ran it the "wrong" way, it would be a slugfest and monotonous after a while (unless that
is what your table likes of course...).
In facing the hill giants, this isn't a straight up storm the complex scenario, and we've faced cascading failures and had to flee. In a direct fight, we would all die. We used a lot of stealth, scouting, planning, separating foes, controlling the encounter, using traps, gaining allies, and all sorts of things to succeed. Even then, our "success" has cost us--one comrade captured and taken ahead, others captured, tortured, managing to escape, but with the loss of our most powerful magical items and best equipment.
We venture onward to rescue our comrade, with less power and more dire straights, facing more powerful foes. The situation will be desperate many times I am certain, but the risk and the reward are what make it as great as it is!