I think this page deserves a link here:
https://simonschreibt.de/game-art-tricks/
This is an analytical breakdown of various tricks used in games, including VFX.
Sometimes it’s simple small tricks, sometimes big analysis like for the Wind Waker!
All this is courtesy of @simonschreibt - thank you very much for all this work! 