Emporia Vue has circuit level monitoring. You can flash ESPHome to get rid of cloud functionality.

This is great. I tried putting a shock sensor in my metal mailbox which is attached to my building and couldn’t get the signal to reach. This is a whole other level of advanced work!

You already have a pihole. I assume you like it. You could buy a cheap minipc/NUC and set up proxmox on it and learn to set up and configure a second pihole as a virtual machine. Then you’ll have a server running with the ability to expand as needed. You could look into setting up new network gear (like tp-link’s omada) and run the software controller in a VM. Or you could dabble with HomeAssistant and get into smarthome. Or set up a photo management tool like Immich. Like others have said, find a problem you want to solve and use these tools!