Openspf.org has a page about that [1] which recommends email providers allow their users to configure authorized forwarding sources as exempt from SPF checks on their incoming mail, and default to not rejecting based on SPF when users haven't configured the preference. But in my experience few institutions follow this recommendation.
Once I ditched the SPF records, I've had no deliverability problems running my own mailserver.
GMail was the only one I had that problem with because few mailservers are using IPv6.
Gmail seems to accept mail from an IPv6 mx when the SPF record is "All the A records for all the MX records" (the headers says spf passed), but I'm not sure how others interpret it. Is it better to explicitly list the IPv6 addresses in the SPF record?
To make sure that my messages are not treated as spam by the major email providers, I checked that my VPS IP is not in any of the spam blacklists and configured SPF and DKIM records. Gmail spam-flagged the messages for a while, but after a couple of months it learned they're not spam. Surprisingly, other email providers (yahoo, ms, aol) never batted an eye.
I'm quite happy with my own server.
[1] https://honeypot.net/filtering-spam-with-postfix/