so there are 2 types maybe more but what you said is about 2 different types of systems.

IP cameras are basically network based cameras. So they use ethernet or wireless to connect to your local network.
So they don't have to plug directly into the dvr(recording system) for them to be recording.

The other type of camera is a direct connect camera, it doesn't have any brains other than it being a camera. It has to direct wire to the system that lets you view or record off those cameras.
Think of it like just a camera with wires hanging out the back that has to hook to a monitor to see what is happening.

Most modern camera systems are ip cameras.
Reolink is the better choice so far for regular non-tech consumers.
There are other software and camera setups the more technical you are to set up stuff on your own.

the poe type cameras are just a type of ip cameras.
you then only have to pull 1 cable to hook it into your network.
Wireless cameras are ip cameras but they still need power instead of power and network, or poe network type stuff.
At this time it isn't that much more expensive to do POE over regular ethernet.
Most people feel wired is more secure due to hacking and jamming.
If you have a wireless camera I can flood the area with 2.4ghz signals and jam the feed to your monitors.
or hacking could do 2 things. Take one over so I can see what you see, or turn it into a bot to do denial of service attacks.
POE is just more convenient by only needing one wire.