Sorry but even when the focusing elements move independently from the rear lens group, you can always achieve macro, you can try for yourself. But even with "old" lenses, using the focusing ring is pretty useless anyway in macro photography, you focus moving the whole camera. I work a lot like that for extreme close ups, having a nice set of M42 extensions tubes. I actually use a Fujinon 54-270 with independent focus barrel (as it's a zoom lens) with which the minimum focusing distance is so far (2.5m) that using extension tubes are the only way to achieve close focus. What is true though is that image quality is far from optimal in those cases, but can still be sharp enough.
But getting back to the C to F adapter, the adapter you showed on the link does not seem to have optical elements nor the right flange focal distance. Believe me, if it had the good distance, it would protrudes MUCH more into the camera. Those adapters can't protrude too much because of the moving mirror of Nikon cameras.
Anyway I'm curious, what kind of lenses are you trying to use ? It is said that the 1.8/6-66 and 1.8/10 Shneiders for M-Mount are the best lenses ever in super 8, so I seriously doubt you will have any advantages mounting other lenses, unless you want extreme telephoto with focal lengths greater than 66mm, but in this case any M to whatever SLR mount with corresponding lenses will do the job.