Twain hardware compatible list

Twain compatible home office MFPs.  We are testing the Paperport software with Brother MFC-9340CDW.  The reason for this was the Canon MX series scanner software was acting a bit wonky over the years and the printer is five years old. We actually really like the MP Navigator software but as discussed in our previous thread, MP Navigator is no longer being made for the later MX series.  Thus, we were turned on to Paperport document management software.  It came with the Brother MFC-9340CDW.  Though, I don't think it works with network shares unless I upgrade but I digress.  Anyway, my question is...  Could I have avoided maybe purchasing new hardware and just bought better document management software?  The reason I ask is Paperport prompted me to connect with the Canon hardware using Twain.  Did I just assume most 100 or $200 MFP weren't TWAIN compatible?  A google query of Canon MX twain shows nothing of the sort.  The better question is how common is Twain compatibility (is there a list?) so I can push Document Management software on to some of my other clients?  They too have horrible document management software.