This site generally archives relatively thorough, completed ROM hacks (that is, not those that only change a couple graphics).
(with the exception of those that solely fix bugs in the original games)
zophar.net used to be a good site that saved almost everything, but it really died down as the 2000s went on.
DataCrystal used to, until it merged with this site and the focus changed to more of a hacking notes repository.