From a real world perspective, I think they just found it slowed down storytelling too much. I think the idea originally came from Gene Roddenberry and they had always been trying to make it work.

Ironically in Best of Both Worlds, it's a lure to distract the Borg from the rescue mission, and it wasn't like they offloaded the kids and civilians first. Pretty high stakes gamble on Riker's part.