Honestly I play console games with the original controllers as that's how they are meant to be played. Three are rare exceptions of course, but barring that....
There are various gamecube adaptors out there so that would work, or you can just hack up a gamepad, or madcatz and hori have ready made arcade joysticks for most systems.
It sounds like the type of consoles you want to interface to an arcade monitor aren't particularly suited for an arcade monitor. Older consoles sure.... they run @ 240p so you aren't going to lose any detail hooking it up to a 480i (or less) 15khz monitor. The ps2 and beyond output 480p or higher, meaning you are going to get a degraded signal.
It would be easier for us to help if you post specific games you want to play rather than the consoles in general.
I can give you the short answer though.... hooking up consoles to an arcade monitor can be a bit of a mess. Most of the older ones are capable of 240p 15khz which is good, but often the rgb pins aren't actually hooked up, so you have to hack the console, or the only sync like is the composite line, so you need a sync stripper, ect. Just to give an example on the Nintendo side of things:
Nes: Composite only
Snes: RGB but a sync stripper is often needed.
N64: Svideo only unless you hack the pcb and add a rgb amp as well as hook up the rgb pins.
Gamecube: Very akward to get rgb again without hacking or an expensive cable..... many games output to 480p
Wii: Rgb might be technically possible, but I've yet to see an adaptor sold for it... 100% of the games are 480p
Wii U: Uses the same multi-out as the Wii, so it might be possible, but most games are 1080p.
The Sega side of things is a bit easier, but a sync stripper might also be needed.
The playstation consoles are a mess. The PSX can do rgb just fine, the ps2 can do it but only half the games support it and that's about it.