thing is, nobody knows what exactly is good enough for you. AWE64 has the CQM clone that's derided in these circles instead of the real OPL3, but if you didn't grow up having a card with a real OPL3 it may just still be good enough, and especially if you don't even intend to play many games that only support FM (OPL3) music. so that's a lot of ifs already that you should probably try to answer for yourself.
in general, the AWE64 is a good card and the CQM can be improved by applying chorus/reverb to it (but maybe only in real mode DOS, though, not entirely sure). to be clear, it has MPU-401 support so you can use an SC-55 with it, it is also bug free in regards to the old hanging note bug on SB16s. duke3d is an issue as you have found out, when using the MPU-401 MIDI out for an SC-55 or such, but the problem can be avoided by either dropping the sfx mixing rate down or using seperate cards for sfx and MPU-401 duties. i've not come across this issue other than in build games, because most won't even offer those high mixing rates in the first place.