@debugninja you don't need any sound card in particular, but you do need a sound or game port card that has a MIDI port, as the Roland is a MIDI device.
That would get you fantastic background music for your games, but the sound effects would most likely still be from the PC beeper because the Roland products only do musical instruments.
For video game sound effects the Holy Grail would be an Adlib Gold but they are rare and probably still very expensive so a Soundblaster is your best bet.