The problem with finding a new vent assembly is the the flange on this one is made to match the corrugated roof surface. A flat flange vent would never seal around the edges without a ton of caulk.
If I was more confident that welding in a filler panel wouldn't warp the vent lid and create another issue I think I'd have gone that route first.
The part that gets me is that I've used the same sealers with the same materials on my boat with good results but never where its exposed to direct sunlight on a roof before. This time it let loose when the temps dropped below freezing. I feel its got to do with the dissimilar expansion rates of the plexiglass and steel.
The problem now is that it's too cold to try and seal it again, it'll have to rely on a tarp till the weather warms up.