Abs and acrylic should bond with weldon acrylic solvent. If you want something quick, abs can be solvent welded just well enough for this application.
The avast marine looks like a piece of PVC tubing glued to acrylic. This will only bond using two parts Weldon 40 for PVC to acrylic. I could do it in PVC but I don't have any 4" pvc pipe laying around.
Can be done in acrylic tubing also but have to paint inside black. I think black acrylic tubing might be more expensive.
If you have a 4" media reactor like nextteef or myreefcreations not in use. This can be cut to size added with 3 thumbscrews to the tubing to also make something similar. Just cut off the base. The top or flange can be made clear and the thumbscrews would seal and prevent from both leaking and scratching.
Or the top flange can be replaced if scratched up.
I am not sure with all these camera boxes, I don't know why they don't make replacement acrylic lenses. So cheap. Even the scratch resistant acrylic lenses do scratch over time and need to be replaced.
If you need exact replica of the top flange in clear, let me know.