Forgot to answer the main question. If the game is standard res (CGA), and you have a CRT 60Hz TV (LCD/Plasma typically don't work, 100Hz TVs don't either), it should work. Most gun games have their guns plug directly into the board, so no need to mod the Super Gun itself.
By "standard" res 15kHz/60Hz, I meant a 480i NTSC TV-type monitor. VGA is 31kHz horizontally, not 15! That's exactly what standard res arcade monitors use, which is how RGB out on superguns works fine on TV sets with RGB inputs. IIRC, most orizontal standard-res games are usually around 256x224 or 320x224 (Sega seem to like that one), and occasionally 240 line like 320x240. But that doesn't mean you can't use 480-line stuff on those monitors. I think those tables may be taking resolutions per field - and not per frame - which would explain why it says 240 lines, and not 480. Therefore the medium resolution should be 768 lines. I don't get those horizontal measurements, though - doesn't it vary a lot with different monitors? Maybe that's the calculated resolution, but it probably doesn't mean much in real life. And thanks for the info on guns, tom61!
That table of resolutions is for IBM PC spec, ignore them for arcade monitors. I'm not positive why standard and medium res arcade monitors are called CGA and EGA, my best guess is because they use the same horizontal refresh rates. CGA and EGA in the IBM world are digital for the color data, not analog like an arcade monitor. VGA and hi-res being equated together makes since, as they really are the same thing.