I have no idea what the adapter is you are talking about but I have a general comment. I would not encourage you to even consider putting a lens designed for another brand of camera on you camera, nikon, canon, pentax or whatever.
Different manufacturers design lens mounts for their particular design. even attaching an adapter to a lens to a camera you are changing the optics of the lens by changing the distance from the lens to the mount. to the sensor.
I want a lens to be made by the camera manufacturer or at least be designed for my type of camera.
You mention you could have gotten some great lens for dirt cheap. Trust me in today's world if the lens were worth more they would have sold for more. Most flea market people learn about their stuff today.
I have heard of people tearing up their camera mounts by trying to adapt lens to cameras not designed for them
Bottom line save your money and get a lens designed for your camera. If this was a good thing it would be done all the time. Ever think why it is hard to find out about this stuff?
Just one person's opinion.
Actually, it is done all the time.

Check out
here,
here, and many others sites. For M42 lens reference, there's
here and others places.
Good adapters put the adapted lens at exactly the correct distance to the sensor, so that it focuses the same as an OEM lens.
Now, you may not hear about it for Nikons as much because Nikons are about the worst for using adapted lenses, because of their lens-to-sensor distance. M42 lenses on Nikons can't focus to infinity without the use of an optical element in the adapter. This means that either you lose infinity or lose image quality due to the extra piece of glass. You also have very little choice in terms of adapting other lens mounts. There is one bit of good news - you
can adapt superb Leica lenses.

(The link takes you to a site that sells conversion kits to put Leica lenses on Nikons or Pentaxes, but the lenses are
verrrrrrrry expensive!)
In other mounts, lens adapters are more common. Canons are very flexible and can adapt most other SLR lenses (except, ironically, old Canon manual-focus lenses.) Olympus and other 4/3rds can do even more, and the new Micro 4/3rds cameras can conceivably put just about any lens, SLR or rangefinder, in front of them.
As for tearing up your mount, that is certainly not a big danger with a decent adapter. People trying to adapt their own lenses are usually messing about with the mount on the lens, not the camera.
As for why... well, there are many
superb M42 lenses (Zeiss and the Pentax Takumars are the most popular lenses but there are hundreds more) and many are available for cheap. It's not uncommon for adventurous Canon owners to use old Takumar lenses, especially the fast 50s which are available cheap (especially the F1.7, but the F1.4 isn't much more) and are in many people's opinion, better than the OEM ones. The older lenses also are usually a pleasure to use, with hand-assembled metal bodies and wonderfully smooth focus rings (more so than is possible on an AF lens.) They often give a unique look compared to modern lenses, with a lot of "personality." I often forsake my modern lenses for the M42s just for the fun of it.
If anyone is curious about these lenses on their DSLRs, just throw your manufacturer and takumar into Google. Ie, "canon takumar", "nikon takumar", etc. This is an easy way to find messages from forums where people actually use the lenses.