You would be
seriously surprised at the number of obsolete lenses which can be made to work, and work well, with a modern dSLR camera. Adapters exist for virtually every older lens mounting system which was produced in any real numbers, and machining a mount for one which doesn't exist is a relatively easy task for any experienced machinist.
You'll be giving up the "automatic" functions, of course, but a dSLR is not designed to work on "automatic" anyways. That's basically a lowest-common-denominator effort by the manufacturers so they can sell expensive cameras to people who don't really want to learn how to take pictures. With an obsolete lens, you're 100% manual in almost every case, including focus. You have to figure out how they want to work together - aperture I most difficult. Maybe you'll want to set the camera wide-open and adjust aperture at the lens; maybe vice-versa.
Here's a few rules of thumb for experimenting with older lenses, and by this I mean "regular" photographic lenses as opposed to the dedicated copying lenses which rmpsrpms has so ably demonstrated do not have to be expensive to be
good:
1) Prime, not zoom. Prime lenses work at only one focal length, and are as a result far less complex than zoom lenses, and include far fewer compromises to optical quality. Use *any* prime before *any zoom,* even if that zoom is a $2000 Canon L-series (well, maybe....)
2) Get a lens with the widest-possible maximum aperture. This will be indicative of higher initial quality, as it is a real challenge to create a lens offering both optical quality and great light-gathering capacity. For lenses under 85mm focal length, settle for no less than a maximum aperture (lowest numerically) of f/2.8 or less, preferably at least f/2. The longer the focal length, the more you can adjust this number and still expect quality. Over 100mm, a minimum of f/3.5 is quite acceptable. But....
3) Keep it short. As in, focal length. As in, 50mm and not much more. We're talking about shooting entire coins here, not microscopic details (although most primes react very favorably to various means of making them magnify, like bellows and extension tubes). Focal lengths of greater than 50mm begin forcing you to back the camera further and further from the coin in order to get the whole thing onto the sensor, and older lenses (except those of the highest quality) tend to have greatly-increased minimum focus distances as their focal length goes up; a 150mm telephoto may require you to be 3 feet from a coin before you can achieve focus.
This does not apply, of course, to dedicated "macro" lenses designed to focus at shorter distances.
For many years - pretty much forever - 50mm was the "standard" lens focal length.
Everybody made them. There is a bewildering array of obsolete lenses available in this focal length, and wider apertures are not expensive. At 50mm, even with cheap older lenses, a maximum aperture of f/2.8 represented an inferior product. f/2 is where you start seeing quality at 50mm with older lenses.
I have a rather nice original Asashi Pentax SL film SLR with a Super Takumar 55mm f/2 lens which I am frothing at the mouth to mount on a Canon dSLR to see what it'll do with a coin. Pentax Takumar lenses use the M42 screw mount, which mount was used by a staggering number of differing cameras and lenses. Adapters to modern Canon, Nikon and other dSLR's are easily available for M42 and cheap - a whole lot of people are doing this and a whole lot of lenses are available for a pittance on
ebay.
Keep in mind, we as coin photographers have the ability to work around the limitations of a lens like few other specialists. All we require is a lens which will achieve focus with a coin at a reasonable distance from the sensor. Chromatic problems we can compensate for with custom white balance and postprocessing. Aperture limitations we can defeat by bringing as much light as it takes to illuminate the coin.
Coins don't crawl away. We have plenty of time to tweak things to make it right.
I can see myself, in the future, getting bored with using great optics to shoot coins. It's not a challenge. Then it'll be time to start using "inferior, obsolete" lenses to achieve the same quality I could with bespoke glass. Kinda like abandoning the rifle in favor of a handgun for hunting (which I did back in my hunting days) to reintroduce the "challenge" to the process.
So, if you want to shoot coins using cheap older lenses: Learn the process. I mean, learn it until you're instinctively changing settings in the right direction. That won't take as long as you think.
Acquire a lens of around 50mm, no more than 85mm, and a maximum aperture of no worse than f/2.
Shoot pictures.