The first few gens of Nintendo DS run-your-own-software devices couldn't run (current gen) games due to ram limitations. They could only be used for say (NES) level piracy or current gen homebrew. Media playing too (MP3/OGG/Midi even), although video was limited to needing special lightweight format that made it too much bother to be worth it.
As for homebrew/"real devs", depends what you define as "real devs". The 3DS certainly got a handfull of download titles that were first DS homebrew.
My interpretation is that homebrew as a concept is bunk
My personal DS favorites were Colours (painting app, now well superseded, but for the time the smudge tool alone put it in front of most things), Moonshell (decent function OS, with the above mentioned media features - the Midi support even let you use your own wavetable so things could sound decent), various FT programs, emails. Puzzle Manik was good very functional generator of a dozen or so newspaper style logic puzzles (later split into pieces and ported to iOS as a commercial app). Ports of various things of course. A 2d Portal game, a few gravity based puzzlers, a limited version of Knytt Stories.
Remember this was on the DS - before many had even a smartphone. Even a simple media player and email checker was useful.
My personal favorite "omg seriously" homebrew....which I suspect most wont believe....was a actual way to get auto-stereoscopic images on a first gen Nintendo DS.
It worked (yes my 3d vision is just fine thank you).
Apparently the top screen, has a slight parallax barrier effect as a side effect of its manufacturer process, allowing a rather crafty homebrew to exploit it. The exploit for some reason was only greyscale, but was pretty impressive for sheer "coming up with something it was never designed for" wow factor.