PleaseNSFW said:
Anyone know what this camera effect is called? And some more examples of the effect. Thank you
That is called "macro effect." It can be added while shooting a photo or later via Photoshop for example. Check out this video for an example: