Spinzilla, I haven't heard anyone mention playing their own tunes during games. The audio feature has some themed visualizers and does play music while closed. I think it stops playing if there are no headphones, which effectively cuts the DSi to being a instarocker machine, but I am not sure at the moment.
Are there any details about the SD card slot and file types that can be used aside from AAC?