I know he's basically left the novels now, but I think there is a lot still worth mining from his character.
Much as I like Ross, I'm hoping we don't ever see him again, post-Articles. He walked out of Bacco's office into quiet retirement and he's going to keep his head down so that Section 31, etc, doesn't decide to categorize him as a major risk. I do very much want to know if he survived the Borg Invasion, but I think it works better to have him truly written out of the cast. I'm content to wonder.