Hey Dan, I asked the same question a few months ago. I get out to Kingston quite often for work and was wondering myself. I didn't get much in the way of responses.
What I can tell you is that there are walleye, bass, pike, musky, sturgeon, hell just about everything in the St Lawerence but I don't know of any good spots as I haven't had the chance to try yet. The Cataraqui also looks very fishy to me, I'm thinking there has to be bass and pike in there, but again haven't tried. Sorry I can't offer much but thay's what I think.
Alfie.