Retro console homebrew and demoscene are all about this. There's a lot of fun stuff going on in N64 homebrew right now: https://www.youtube.com/watch?v=rNEo0aQkGnU
For the rest, yes, it's really astounding until you push these polygons while moving around in a game loop...