Depends upon your specific limitation: What CPU are you using? Are you tied to 8-bit ISA slots? 16-bit? Is PCI available? etc,etc,etc
"Better" is a subjective term. Certainly, an SB Pro 2.0 is technically better than the SB 1.5, but you may prefer real CMS on the 1.5 vs the simulated CMS on the 2.0, or you may prefer the optional WAV add-on of some of the later SB cards, or even the Gravis boards.
Or you may want to go a different route and use an audio card with a waveboard attached. I have a Sound Blaster 16 and a Turtle Beach card for those purposes.
I personally run a SB1.5 in machines up to/including 286, SB2.0/SB16 up to/including 486, and Awe64+ on Pentium-level. With the smattering of Turtle Beach, Media Vision, and Ensoniq offerings in the pile to play with when I choose. You can run a Roland synth (MT-32,SC-55,SC-55MKII) off of the joystick/midi port on the Sound Blaster series, as well as most others, so "better" is really, really a subjective term. I tend to just go with what sounds nice in relation to the system that I'm using.
Though I would really like an early and late-revision Gravis Ultrasound to toss in the mix. I've never actually gotten to hear those pieces used, and I know that several of my favorite shareware companies developed with them.