I think that most anyone can do photo &/or video editing, but software unfortunately seems divided into two tiers -- stuff for pros, that's also used by enthusiasts who've put in the time to learn apps that aren't designed to be easy, and stuff that's easy to use, but with a design & marketing that's so focused on ease of use, that the software itself doesn't do much. I wanted to talk a bit about Easy Photo Unblur, that was on GOTD recently, Franzis Focus Projects, which Franzis seems to be promoting currently, and similar apps & plug-ins.
This software can be useful, but isn't always -- you need a sense of when it might help I think, or else you might try it once, see that it didn't do anything, & throw it away [or see that it helped, buy it, & then find out it's useless on most of your other photos]. It helps I think to have an idea of what sharpening software does, because that can tell you when & where it might be useful. You won't find out much from the pros & semi-pros, because I don't think they tend to use this sort of thing -- unless it's really unique, photos that aren't sharp enough just get tossed aside.
It's the edges in an image that determine how sharp it is, or isn't. Biz graphics are usually as sharp as you can get, because they usually use vector graphics. Vector graphics tell a device like a PC or printer to draw a line between point A & point B, & it's drawn with edges as clear & well defined as the printer or display is capable of. Vector graphics don't care how large you print them -- they're as happy on the side of a bus as on a postage stamp. Something like a bar chart would show a red bar for example, have a row or 3 of pixels or dots form the often black border, and boom, there's the white background, with no transition whatsoever.
Photos are Raster images, & they're a bunch of colored pixels or dots. The only way to have a raster image as sharp as vector graphics is to convert vector graphics to raster [it's called rasterizing], but it's only good for whatever size you choose when you rasterize that graphic -- change the size & sharpness suffers. [Fonts are vector graphics BTW. When you add text in an image editor it starts out as vector graphics, then once it's colored & sized how you want it, that text is generally rasterized to become part of the image. From that point on you cannot change its characteristics nearly as well.] Raster images created almost any other way will not have edges that are not so clearly defined. Zoom in far enough on a raster image in software, & you'll see a variable amount of chaos at the edges of objects & their features -- at normal zoom levels that chaos blends, so we see objects that are sharp, or not so sharp.
Several things can make photos not so sharp... Some cameras & lenses just take sharper photos than others. If the camera lens is not well focused on an object or objects in your photo, the edges of those objects will be spread across several pixels -- how many depends on how out of focus the lens is. If the camera &/or the subject you're photographing moves while the shutter is open [while the sensor (or film) is still collecting data], you'll get more than one under exposed image of that subject. If your camera adds noise to a photo [think of a variable amount of scattered, wrong colored pixels everywhere], everything, not just object edges, is less well defined. If in-camera or PC software adds blur, instead of more random pixel chaos you're more likely to see pixels blending &/or merging.
Noise is the one problem you *might* have the most success trying to fix -- software basically looks for pixels where the color doesn't match their neighbors, & re-colors them so that they do match. Franzis Focus is much more about noise, detecting & correcting for it -- they also have a more general app called Denoise. Both may improve noisy photos, regardless how sharp they are or aren't, but will only help when/where noise is a problem. There are several apps or plug-ins for noise, & many editing apps have their own noise filters. You do have to watch though because sometimes all they'll do is apply blurring, rather than attempting to actually fix something.
Motion blur [when the camera &/or subject moves] is probably the most hopeless -- when an object [or its edges] appears more than once, how does software know which occurrence or appearance to fix? When an object [or objects] has a focus problem, or when the camera & lens simply takes less sharp photos, software can try to find any edges, & increase their light to dark contrast -- it's not really fixing anything, but tricking our eyes into seeing the object(s) as sharper, or more clearly defined. With this method finding edges is critical, so mileage can vary [sometimes much] more than with a noise removing app or plug-in -- if an edge doesn't have highly contrasting colors, &/or is too spread out across too many pixels, finding edges can become very iffy.
Easy Photo Unblur fits into the category of software that looks for edges so it can increase edge contrast. Many editing apps include a high pass filter that you can use, or at least an emboss filter that tends to have the same results. Google comes up with 84 million hits for "high pass image filter" [w/out quotes], so you should have no trouble coming up with tutorials & how-to articles for whatever editing software you're using. The idea is generally to use the high pass filter to find edges, then blend that with the original photo. While more work than Unblur, one advantage I can see is that using the high pass filter you can control what parts you want to blend with the original, and what parts you want to leave untouched.