His signature hit, “So Into You,” was omnipresent in 1994 — the rare record “you heard at every club,” one D.J. said. But his time at the top was brief.