How good is my computer compared to today's standards?

If you're planning to stick with it, max out your RAM. 512MB is pitiful, it might be possible to max it to 2GB but you need to find out the mother board specs. As far as your second question, Core2 Duo is superior to any Pentium 4.