Intermediate-luminosity red transients: Spectrophotometric properties and connection to electron-capture supernova explosions