Probably Rise of the Triad.
Pretty sure I even bought the full game and never ended up getting very far. I also remember spending a little chunk of time on Hugo 3: Jungle of Doom, but could never figure it out enough to progress very far.
Edit: Another one I was trying to recall, the name was H.U.R.L.