Gonna go against the grain here and say no.
Octoprint needs to stream commands in real time to your printer, I'm sure I've read somewhere that putting too much load on the pi results in print quality problems.
There's also the reliability factor, I have a decently specced home server (Ryzen 7600, 32GB RAM) and I don't run octoprint on it, because I don't want stuff I'm doing on my home server to interrupt and kill my 36 hour print lol
Also, Pi kinda sucks as a media server, how you gonna connect storage to it, USB drives? If so that'll burn even more CPU time.
I think it depends on your use case.
If you live alone, or maybe with one other person, the people staying at your house don't change, then why bother with SSO?
If you're like me, have 4 people living in the house, 2 are lodgers, sometimes people come and stay for a while and need home assistant access, different people need different privileges, you need to provision wireguard for everyone, etc.