I’ve never tried Yunohost, but it seems to be popular. I think your assessment is pretty good. Simpler services should work quite well over boringproxy. I’d be more wary about chatty protocols.
There was a user a while back who ran into issues trying to run Matrix (Solving tcp over tcp slowdown, adding sshuttle support?). Not sure if ActivityPub (Misskey, Pleroma, etc) is as chatty as Matrix but you might have similar issues.
I’m (slowly) working on a successor to boringproxy that supports QUIC tunnels. This should make it less likely to run into performance problems. The connection speed can still be a bottleneck, but it should make more things work.