Thanks for brilliant reply Chris. In an ideal world I would like a program that biologists could use, that's partly why I have focused upon commercial software. The other half is while I can use free software it usually takes months to get legal approval. But both those issues though really come second to the best scientific solution.
Your interpretation of my question was pretty spot on (tools on surface seem to be able to do as I wish, but its really what content they can offer). Part of the problem though was my lack of understanding with pathway generation.
By reading your post it seems I was under the wrong impression of how this is achieved, I had thought that new bacterial genomes got automatically mapped onto metacyc/kegg and then manually curated. I had hoped (it seems unrealistically) that these commercial tools would draw on multiple sources (public and private) and integrate it all in one semi- automatic solution (perhaps even do subtractive differentiation) . The goal being that as soon as a potentially interesting new pathway became available (eg by chemical structure), or potential candidate enzyme that may fit my custom pathways (by homology, Go annotation) I would become alerted for further investigation.
As such I can't work on a specific species, as the aim is to concentrate on approx 100 non-natural substrate/products/intermediates and discover which bacteria may act upon them (as they become available), to help generate a new pathway.
At the moment I rely upon databases I generate myself with inspiration from EC-Blast/cyc databases to generate novel pathways. But the best solution is to start from the best enzyme in nature/high jack native pathways (in whatever species that may occur).
It's a shift in this emphasis from discovery to finding the optimal solution (or other routes to same product) which drives using pathway centric approach to help generate the best solution.
I realise that there is nothing out there that can do everything I want to it to achieve but I was hoping that these tools might go a long way in helping to achieving that.
Openphacts was a particularly good tip!
For what it's worth, you can demo IPA for a little while for free and just directly gauge how well it works with your data.