There doesn't appear to be any comprehensive list of games/series whose not (allowed) on this site. There are a few I've noticed.

These games do not allow their leaderboards to be copied: • Super Metroid • Donkey Kong Country 1-3 • Halo 1-5 + Reach • Super Mario RPG • Super Star Wars 1-3?

These games DO allow their leaderboards to be copied: • The Legend of Zelda series • Mega Man series (discussed in another thread)

There's probably more I haven't noticed. If you know of one be sure to mention it here.

Castlevania has their own site. Still not sure what their agreement is. http://cvspeedruns.com/