Are the cheat codes shown in the rules for each category, ones that can only be used on emulator like PCSX2? Also how do you even use them?

They can be used in Dolphin or on a real gamecube with an action replay device. On Dolphin, right click Spider-Man 2 and press "Properties" > "AR codes" > "Add new code..."