The phrase "a sight that had" is correct and usable in written English.
It can be used when describing a visual experience or observation that occurred in the past.
Example: "It was a sight that had captivated everyone present at the event."
Alternatives: "a view that had" or "a scene that had".
He left the court and headed for the locker room — a sight that has become all too familiar for the Bulls.
Jeter scored on Hideki Matsui's two-out single, then pumped his fist after he scored, a sight that has become familiar for the Yankees.
One team will wear "New York" across the chest, the other "Brooklyn" — a sight that has not been seen, on any playing surface in major professional sports, in a half-century.
When he got back to the dugout, he did his usual nonstop celebrating, a sight that has become very familiar to Mets fans but maybe not so acceptable to a division rival.
But as residents here have discovered on closer inspection, it is in fact a grand piano perched upright on a narrow sand bar in Biscayne Bay — a sight that has inspired wordsmiths to compete to name South Florida's newest curiosity ("piano bar" seems to have won).
What I found on the beach in Periyamudaliarchavadi was a sight that has become all too familiar around here over the years: fallen trees, concrete debris, churning waters perilously close to people's homes, and bits of human lives — combs and bottles and rubber sandals and pieces of furniture — strewn across a narrow strip of remaining sand.
An ice-free patch of ocean about a mile wide has opened at the very top of the world, a sight that has presumably never before been seen by human beings and is more evidence that global warming may be real.
What I found on the beach in Periyamudaliarchavadi was a sight that has become all too familiar around here over the years: fallen trees, concrete debris, churning waters perilously close to people's homes, and bits of human lives combs and bottles and rubber sandals and pieces of furniture strewn across a narrow strip of remaining sand.
