They wouldn't be worthless if the hit were sufficiently devastating, but no edition of D&D has given heavy crossbows that punch.
ROF 1/2, damage 1d20 might be a reasonable tradeoff. Or possibly 1d10 damage and an armor-piercing mechanic (e.g. ignores piercing resistance, +2 to hit vs heavy...