I do run Piped locally for my family’s use, it seems that it works better than public instances but I haven’t really measured to what extent (except for ping, which is obviously excellent at 4ms).
I would say that the problem with self-hosting for private use is limited privacy, as the benefits of grouping multiple users behind the same proxy are lost. I try to mitigate this by routing all piped traffic through a VPN though.