The many flavours of photometric redshifts