Well I don't have any personal experience with it myself, but what I have heard from forums, youtube, etc. is that for graphics/music, the changes appear on your console, not anyone else's, and the game still runs fine. When there are gameplay hacks though, the gamestate is different on different consoles which causes an eventual desync.