Well, then, it's a lot like discussions about noise and sensor resolution, as well as how sensor size compares in regards to resolving an image. A lot of the differences are technical but as to how it affect your images in real life usage, well, it depends. Large prints or close crops can show up, well, all that jazz. But for many/most people it will likely not be an issue. Your occasional poster-size prints, well, hang 'em in a way that won't enable close up viewing!
I have occasionally shot at very narrow apertures, both for some good close-to-distant depth of field on some scenes and then when doing macro photography. Even thought I prefer to stick to more "normal" apertures (flike f/16 on a full frame or, if I can, f/11 on a crop body) I have on occasion pushed to say f/22 and been quite satisfied. Yes, when viewing fine details at 100% there would be a bit more softness than I'm used to but when printed at one of my "normal" print sizes (like 12x18") then, well, a good shot makess a good print!