"VGA" is "RGB". The terms are used somewhat interchangeably in some circles, though they don't really talk about the same thing ("VGA" is a full specification from VESA involving everything from video timings to electrical parameters to connectors while RGB is simply a colorspace that you can represent images in).
You can buy cables that have your HD15 VGA connector on one end and 5 or 6 BNC "RGB" connectors on the other end. Since you only have 5, that means you have composite sync. Many PC video outputs can do this, but not all. A small external circuit can combine separate sync into composite sync if necessary.
Quality on any of the RGB inputs should be identical.
That monitor will do 640x480 but not 800x600, so you'll have to drop Windows or whatever OS down before hooking it up. It will also do CGA and EGA timings commonly used by arcade games. If you want these timings from a PC, you'll have to get them via a method of your choice (Soft15k, ArcadeVGA, other software/driver tricks, modeline in X, etc.).
If you have an actual arcade board, you'll want to hook it up to the TTL RGB input as arcade boards use those signal levels rather than the 1Vpp signal levels used by most other devices outputting RGB (including PCs on the VGA port).