Are there any general rules to be extracted here? Surely not. Some unsharp pics work; some don't.
To go back to what I think I understood in the original post, yes, I find a Leica mighty liberating next to an 8x10 inch or bigger, or even roll-film, and I certainly felt a flash of recognition when I read the post.
Overall, I get better pics from my Leicas than from all my LF kit (4x5 to 12x15 inch) put together. But there are others who love the whole LF ritual and process. Best of luck to them. Who cares? We're all doing this either for enjoyment, or because it makes money, or sometimes both, and trying to lay one person's trip on another is not very profitable.
I'll often use long and VERY long hand-held shots. Some work. Some don't. Some, I really think "if that were sharp, it would be great." But I get enough that I do like, with long exposures, that I carry on doing it.
Cheers,
R.