https://www.mouser.ca/ProductDetail/Olimex-Ltd/ESP32-POE-ISO...
1- https://github.com/cnlohr/espthernet
2- https://github.com/cnlohr/espthernet/blob/gh-pages/hardware/...
https://www.ieee802.org/3/cg/public/Jan2019/Tutorial_cg_0119...
For USB-powered development boards IMO the best option is the raspberry pi power supplies -- they are cheap, high quality, and can supply plenty of current. It's sometimes necessary to bridge over the input diode if you want to draw any significant current from the 5v pin.
If making your own boards the maximum 3.3v current is higher than you might expect (0.5A), but it's perfectly doable.
Getting a UPS for my Home Assistant node was the easy part. Like you, I was worried about the many nodes scattered throughout the house that needed power.
The solution I've come to for now is using a USB plug for mains power, that goes through a DIY USB battery bank charging board (that I got off AliExpress) that's plugged into an 18650 cell. Most of these boards can either charge or provide a 5v out, but some are happy to do both at the same time, and can act as a mini-UPS.