Do you have experience with the Cisco SG250X-24P-K9-EU switch?

Somehow, the question of how competent the OP is in network matters in general and Cisco in particular still hasn’t been answered. Without prior knowledge, it is hopeless; with general prior knowledge, the "Cisco Switch" project is still at least very challenging. As a CCNP, of course, it looks different.

My knowledge is limited to what I learned during my training and rudimentarily acquired on the job. Professionally, I have little to do with spanning tree, trunking, routing, etc. Of course, I can handle all of that, but it's simply not my area of responsibility. Again, I came across the switch because it can do more or less everything "out of the box." I don't need an additional router for VLANs and it supports IGMPv3. I simply hope to accommodate VLANs, VLAN routing, PoE, and Magenta TV in one device with 24 ports or more. If anyone has an alternative, feel free to share. The Edge series from Ubiquiti seems to be an alternative. Has anyone ever held and used such a device?

As I said, I have two of them in use and also operate VLANs with them.
Upstream is the USG-Pro-4 from Ubiquiti.
I don't have MagentaTV, I only use FTTH from Deutsche Telekom.

Find routing belongs on a good firewall with zones and a certain broader range of functions instead of static routes on the switch

In principle, I agree with you. But what added value do I have in a single-family house through a proper FW? I do not want external access.

I have two of them in use as I said and also run VLANs with them. Ahead is the USG-Pro-4 from Ubiquiti. I don’t have MagentaTV, I only use FTTH from Deutsche Telekom.

Do you route the VLANs over the USG or the switches?