Slimebeast, before you do anything, don't buy that 360 VGA adapter for $50. I know a guy who sells it for $20 brand new. I bought a sealed official 360 VGA adapter for just $20 from him.
http://store.richspsxparts.com/newxb360vgac.html
I don't know if this is the cheapest you'll find it for but all I know is, I got an official MS VGA adapter for just $20 brand new.
You also may need to buy an extra audio adapter (it's cheap though) if your speakers can't take red and white AV cables natively.
If you want a solution for a PS3 too, you are SOL. HDMI will work with both consoles but your monitor doesn't have HDMI. Anyone know if the PS3 supports VGA? If so, maybe there's a VGA adapter you can use with the PS3.
Oh and as mentioned on here before, I don't think DVI or HDMI is really an upgrade from VGA if you are using a 24" monitor. Once you go from SDTV to VGA (especially at 24"), you will notice a big jump in quality. And in-game text won't be eye raping you anymore (I have nightmares thinking about Tropico 3 on a SDTV. Good lord. Worst SDTV text evar!) But VGA to DVI or even HDMI at 24"? I doubt it.