My main hesitation on running anything mission critical is the reliability of sd cards.

They are pretty great for anything that can be easily replaced imo. Thinking octopi, pihole, pivpn f.ex.