I think the appeal is the ease of distributing to others. All the functions I've written that I use regularly are sitting in autoloading paclets, but that's not something I can quickly (or easily) give to a beginner user for them to use.
I don't think it's documented yet, but you can use "DefinitionNotebook" as the second argument to ResourceFunction to view code. Example: ResourceFunction["CheckMatch", "DefinitionNotebook"]