There's actually a few issues that come into play, first, when you first install stick, the motherboard defaults to either 1333 or 1600 and sets a generic JEDEC based set of timings which should hopefully match up to default timings in the SPD of the DRAM sticks themselves and should allow you to boot most any stick up...9if the BIOS is well written and some are not), see my QVL info thread here:
http://www.gskill.us/forum/showthread.php?t=10566
Then it can be more difficult, though it shouldn't be, most all sticks 1600 and above now need to be configured to the mobo to run at rated freq, Intel uses XMP as the easy way, and AMD uses it's own style of OCing profiles, most popular is called DOCP (some are even starting to use XMP), this takes a profile off the SPD and offers it to the BIOS which then, if it can sets the sticks up as they should be, this is where problems often occur as the BIOS can't always set the sticks to the optimal timings/settings (which is a BIOS programming thing, which is why you see so many BIOS updates, generally 50-75% or more of BIOS updates are really for DRAM and XMP compatibility)
For basically true 'plug and play' and doing nothing you are limited to 1333 or 1600 if the mobo supports that freq at boot, otherwise with Intel on higher freqs XMP will work, generally with slight adjustments the manufacturer or someone knowledgeable w/ DRAM can provide...I help on support at GSkill and do so because I have found their sticks to be great, and they have knowledgeable techs and field engineers that are in and out of the forums on a daily basis