The most interesting speedrun I've ever seen is the Super Mario World credits warp, which requires the player to write + execute arbitrary code in game by carefully positioning koopa shells. At first thought to only be possible with tools in an emulator, this has been done on an actual console!
Summoning Salt video about the overall history of SMW speedruns: https://www.youtube.com/watch?v=USBboeK7oDA
Detailed explanation of how the credits warp exploit works: https://www.youtube.com/watch?v=vAHXK2wut_I