Almost all front end can work on your machine. It depends what you are looking for.
As you have a Arcade VGA, i suppose you have a 15khz screen.
In that case i would suggest , Mala or AtomicFE
If you want something sober, effective , Mala is a good choice.
If you want something with lot of more graphic possibilities and effective as well , try mine AtomicFE.
You have also Maximus Arcade, but you have to pay for and i think the customer "support" is not as good than mala or Atomic one.
GameEx , you have to pay too , very good, but i 'd say less "old school" . But good support too.
Hyperspin , very nice , but use lot of resource of you computer , therefore i don't think it is the best choice for a 15khz screen. AtomicFe can do almost the same things graphically but where Hyperspin need a 3ghz machine with 1giga of ram (what you have, so no problem) , Atomic does similar thing with only 1ghz and 256mega.
In fact it is just a matter of taste , try them . Have a look to Mamewah too..
All Fe have their good and bad.

and have a look to the wiki :
http://wiki.arcadecontrols.com/wiki/Front-Ends