The USB thing, while not great, was a bit overblown. Official power source never had a problem. As far as overheating, there are several passive cooling cases

The USB thing, while not great, was a bit overblown. Official power source never had a problem. As far as overheating, there are several passive cooling cases that handle the heat just fine. ETA Prime is one place to look for videos with tests. No doubt you get more power and flexibility from a NUC, but Pis are pretty great for what they are.