My normal method is to hack off the SCART connector since (here in the USA), SCART sockets are almost impossible to get hold of in small quantity.
You'll have an orange, green, blue, yellow, and (usually, measure 5V with a multimeter to the black ground wire) brown wire:
Orange = Red
Blue = Blue
Green = Green
Yellow = CVBS (composite video with sync info)
Brown = 5VDC
Black = Ground (video and power)
There will also be some other wires that you don't need (white and red, for example, are audio).
I usually tie the shield to ground as well. This is optional, but can improve noise immunity (or hurt it, if the rest of your ground sucks).
You can try just hooking up the RGB lines to an HD15 VGA connector (pins 1-3 = RGB in that order, pins 4, 6-8, and 10 are ground. If the device outputs sync on green (some do, some don't), some monitors (especially high end ones) will happily sync up. Heck, some will even manage to reconstruct resonable sync from nothing but the blanking pulses!
If that doesn't work (and it often doesn't), get an LM1881 and rip composite sync off the CVBS line:
LM1881 Pin 1 - VGA Pin 13 (horizontal/composite sync)
LM1881 Pin 2 - CVBS from SCART through a 0.1uF capacitor
LM1881 Pin 4 - Ground
LM1881 Pin 6 - 680k resistor in parallel with a 0.1uF cap to ground
LM1881 Pin 8 - 5V from SCART
The other LM1881 pins can be left unconnected.
It's also a good idea to put a 0.1-1uF cap from ground to 5V near the LM1881 chip to clean up the power.
This will give you a valid composite sync signal off the CVBS line. Note that devices which run progressive scan (30kHz, such as a PS2 in that mode) usually turn that line off, so you'll get not sync info then. If that's the case, you can try using the green line instead of CVBS in case sync on green is present.
I have this wired up on a donut board (along with another chip to give me separate sync, which my Kortek seems to really prefer on PS2 signals) zip-tied to the end of a (formerly, until I cut the end off) PS2 SCART cable. Works great on any monitor that supports 15kHz horizontal.