In Turok 2, thanks to a bug, it's possible to use one of the weapon's telescopic zoom with ANY other weapon, effectively turning all weapons into sniper weapons.
Another of the first games where I found the "hide behind scenery, zoom in, crawl one milimeter at a time until the top of the enemy's head is visible, and shoot him" gameplay is Soldier of Fortune.