Much as I hate to say it, I think Sirius is gone for good. He would have come back to help the Order fight, he wouldn't sit around and wait till the right moment.