I am very new to Adobe Photoshop and Creative Cloud and appreciate any advice this community can provide. Sadly there is NO Adobe presales support to help me know if their products will work. Pretty surprising and disappointing and raises concerns about post-sales support.
Why would you even use PS? That's like trying to paint your house with a toothbrush. If at all, this will only work on a locked shot with no motion, but even then the limited abilities of PS to deal with video and e.g. masking out parts to obscure the fence realistically on the video may be a nightmare. After Effects would be a much more appropriate, though in honesty this really is one of those "without seeing your footage, we know nothing" things.
I am totally brand new to Photoshop and video editing so I apologize if the
question seems uninformed and stupid to you.
However, I think you misunderstood the question -- I'm not attempting to
obscure anything. I want to ADD an element such as a fence so I don't
really see why the existing video is relevant.