I don't have the url's handy, but, so far, SnemulDS seems to be the best SNES emu available for slot-1 devices, although it seems like it may be a few months before it plays most games without too much tweaking. Also, there is a very good port of ScummVM for the DS. As far as Emus for Slot-1, those two are the only that I have tried. Concerning other homebrew, video actually looks pretty good utilizing Moonshell and you can actually download some preconverted Bugs Bunny Cartoons and a few movies from another website that I'm lacking the url for right now. (I think it's called the DS library project or something.) Also, I use ReadMoreAlpha for reading .txt files while holding the DS like a book.
The two best websites for information about these are Ds-Scene and GBADEV, IMO. I don't really dig GBATemp, since there seems to be too many kiddies on there to get much reliable information. I do check out their "magazine" and official reviews sections from time to time, though.
But, I actually spend most of my DS time reading comics using the amazing comic/image viewer, ComicbookDS, which you really should Google. It's been developed by some French programmers and you can check out a video of the program in action and download some preconverted comics at their website.