I find this thread a bit amusing.
I have the feeling that the OP is asking questions about things he heard somewhere and also uses technical terms that he might roughly understand, but in my opinion, the network and IT knowledge seems rather rudimentary. And the many suggestions and possibilities only confuse the OP even more and lead to even more questions.
Just the last 3 pages about POE switch behind the TV. I have understood it as him wanting to power only the switch itself with POE from the technical room to avoid occupying an additional socket behind the TV with the switch, and the devices connected to the switch only need the data connection but do not require POE themselves. Yes, such switches exist, for example from Ubiquiti and are called UniFi Flex-Mini.
Regarding KNX and home automation, unfortunately, I cannot contribute because as an IT professional I deal with it every day at work, but at home honestly I am not interested in it anymore. When the doorbell rings, I go to the door and open it to see who is there. If the postman is at the door and I am not home, he should just leave the package with the neighbors. I will see it when I am home again. And I control my lights and shutters in the classic way, by moving to the switch and pressing it if needed. I still do not miss anything at home :)