Swarmkeeper
Hero
There's no reason that that particular consequence would be obvious before the attempt was made, but I have had many players who would scream bloody murder if it happened when they failed a check.
I let my players know the consequences of Ability Checks when I ask them to roll. To me, that represents that their PC is a capable adventurer who has some idea of the difficulty and stakes of what they are trying to attempt in the game world. There is nothing in the rules that precludes this.
Sorry to hear about those players you've experienced at your table. Doesn't sound like that made for a fun environment.