Nah it's kinda shit tbh, I mostly used mine to play original DS games (which has a big blur filter), homebrew on the 3DS is alright but homebrew on the PSP was a far better experience.
Problem for me is, I'm not really into the Zelda or Pokemon games so the most exciting games that came out for it were the mario games (depends if you're into them). There was a nintendogs sequel but I preferred the DS original more.
Super smash bros was fun but then everyone I knew that played it moved on from it quickly, and singleplayer SMB isn't that fun imo.
If you are thinking about getting one and put Custom Firmware on it, you can install the "FreeShop" and get a bulk ticket file to just download any game at anytime on it.
Personally I prefer to play on the DS original with an EZ Flash IV GBA cart + SuperCard DSTwo and stick a pile of fun games on them for when I go on trips. The original DS and GBA had a much better game library imo.