The Fotofield (review available) program is an interesting association of a very easy to use forms designer and small run-time with an interface to the Pocket PC camera API. Users in the field are more likely to have a reason to utilise this program.
For example, real estate agents could easily take pictures of new houses in the market and immediately associate information with each picture taken. Insurance companies could have this program deployed as part of the tools used by on-the road assessment people to capture images of accidents. Or someone involved with the flower market can take pictures of new flowers while travelling in Holland, insert detailed information and send back to a central location where all purchases are decided (no kidding, you should see how flowers are bought and sold throughout the world).
Amateur photographers can benefit of the program too. Or even mobile blog authors. You can take your pictures and attach some data - who/where/how/why - and use this for upload later.
What is really interesting is that users need no knowledge of programming to create a simple to use database (with Insert function only) containing images and related data. This information can then be easily transferred to a PC via ActiveSync or by sending the files via a wireless connection.