Not anymore since they are usually quickly patched...

But holy shit before consoles were connected and updates existed? Yes. I remember TMNT on NES, the janitor bug on Theme Park, the lag glitch in Command and Conquerer Red Alert ....

Honestly even some glitches in modern games can ruin it if the developer is lazy and doesn't fix it. Case example, planet coaster. Can't even run more than 10fps after a few thousand people enter your park.