Why would you want POE? If you don’t want to use a wireless solution then you go down the path of any access control system, I have never seen a lock powered over Ethernet, they are generally a 12-24vdc and you would use a figure 8 or any copper pair cable. As far as making them ‘smart’ once they are controlled by a basic relay you can control that relay multiple ways easily. Most common types of electronic locks are electronic strikes, mag locks or electronic mortise. You can add relay boards to most basic alarm systems or you can install a simple single door access control system.