Yes gamefix is down and has been for a while now. otherwise it would've been solved long ago.
Also megagames has almost no cracks for the games.
However I managed to find my way through crackmanworld and get a working Yuris Revenge crack. Only problem there is that whenever the game is launched through the first decade menu it will complain about wrong disc inserted. Thats because the file the menu launches has CD-checks. However if one launches yuri's revenge directly through the cracked Yuri.exe it works...

Or works... maybe I should say starts without asking for disc or anything. I am still having the problem that the game hangs in the loading screen (before the game menu starts). Happens also when uncracked and running the original disc. Think I will test a reinstall later on when I have gathered the cracks.