There is no single card that will be any less noisy, because there are so many factors at play. Sound Blaster cards in general are very noisy, I've had my hands on a good number of different Creative ISA cards, and the earlier ones were incredibly bad when it came to noise. Additionally, they often had bugs, like the infamous hanging note bug or playing the wrong notes. Those problems are arguably worse than the high noise floor, because they're super distracting. It's not a fun time when a loud high pitched note hangs after a game exits and persists through a reboot until the driver is loaded again to re-initalize the card.
The YM3812 (OPL2) and YMF262 (OPL3) chips themselves were noisy, but could be made worse by bad sound board layout (common with Creative cards) and motherboards with bad cross talk issues, which was a ton of those. Power supplies also could introduce noise if they were low quality junk, which was common in the era as well. Everyone was rebranding shitty cheap Taiwanese PSU boxen and selling them by the million.
If your AWE64 is noisy, maybe try running them in a different motherboard with a different power supply and see if anything changes. You also may try recapping the card, the caps on those cards are 25+ years old and can be degraded. Same with the caps on the motherboard and power supplies.