A new, faint population of X-ray transients