Basically I want to achieve this effect using blueprints if possible, is there a way to have a volume attached to the player that subtracts visibility from select meshes or something similar?
Yes. location based Opacity - here is a link to an official tutorial on the subject.
Thank you so much!