While it is true that many dms ended up using them this way (and most early examples in the books and modules were terrible), a skill challenge can actually be really cool. But you have to dispose of a lot of the clutter surrounding them, starting with the idea that a SC should have a list of skills that are applicable and how you use them. That part is up to the players! What makes a good SC is a dm willing and able to adjudicate that player agency and rule on DCs for their ideas of which skills to use and how.
None of this "I use Stealth to see if I know anything about the carving" stuff, obviously. More like "I know, I'll use Acrobatics to see if I can stabilize the rocking boat!"
The associated skill list was one of the bigger strike against skill challenges. If they were simply "Bet X successes before Y failures. Think up some advancements and setbacks." it could have when farther. It would have force players to thick more about what would make them succeed and fail and forced DMs to do the same. It would have been harder and suggestions would have been offered.
This is where the old D&D favorite, the random stuff d% table comes in. "Every bad thing that can happen scaling a mountain." 45-49. Angry dire goats. What do you do, Sir knight?