Here is an incomplete list of programs that would benefit from an intelligent mode MPU-401 interface (Source: Looking for a list of dos games that require an intelligent mode MPU-401) There are definitely more, such as some of the Ultima games.
A-10 Tank Killer
Codename : Iceman
Companions Of Xanth
Conquests of Camelot
Curse of Enchantia
David Wolf
Ecargxus
Eric the Un […]
Show full quote
A-10 Tank Killer
Codename : Iceman
Companions Of Xanth
Conquests of Camelot
Curse of Enchantia
David Wolf
Ecargxus
Eric the Unready
Gateway
Gateway II
Hero's Quest/Quest for Glory I
Hired Guns
Hoyle's Official Book of Games Volume I
Hoyle's Official Book of Games Volume II
Innocent until Caught
It Came from the Desert
King's Quest I : Quest for the Crown
Kings Quest IV
Laser Squad
Leisure Suit Larry 2
Leisure Suit Larry 3
Linewars II
Martian Memorandum
Mixed Up Mother Goose
Police Quest II
Princess Maker
Princess Maker 2
Sabre Team
Shadoworlds
Silpheed
Simon the Sorcerer
Sorcerian
Space Quest III
Spellcasting 101
Spellcasting 201
Spellcasting 301
Superhero League of Hoboken
The Colonel's Bequest
Thexder II
TimeQuest
Waxworks
Wing Commander
Wing Commander II
Wonderland
Zeliard
If those games do not interest you, then you're probably fine with non-intelligent mode MPU-401 capabilities.
As to what the best way to connect the AWE64 to an external MT-32, the answer is that it depends.
SoftMPU is of course a "free" option once you've got the gameport-midi cable connected appropriately, but not every game will work with it since SOFTMPU requires EMM386 4.46+ (MS-DOS 6.2) or QEMM 7.03+. Games that break when either of these memory managers are loaded won't work with SOFTMPU.
The more expensive option is a hardware solution such as an original MPU-401 ($$$$$), certain legacy MPU-401 clones that specifically support intelligent mode ($$$$), or more modern solutions such as HardMPU (which you already mentioned) or PCMIDI; incidentally the Orpheus Sound Card is a popular modern solution which can include intelligent mode MPU-401 as an optional add-on.
As far as a cable, if you emulate MT-32 on another PC via USB then you can't go wrong with purchasing a Roland UM-One mk2 and calling it a day. Otherwise, for DB15 to MIDI I'd look up Serdashop and purchase one of theirs. You can daisy-chain them this way:
PC --> SC-55 mk II --> MT-32
The SC-55 mk II can run the data to the MT-32 with just a dumb MIDI cable.
Good luck!