If your pre-AI/non-AI lens has NOT been converted to AI, then you MIGHT be able to CAREFULLY mount the lens on a Nikon DSLR body that has an AF motor (which is everything but the D40/x, D60, D3000/5000).
The reason being that pre-AI/non-AI lenses have an aperture ring that does not have cutouts for the plastic max-aperture tab on said Nikon DSLR bodies. If forced on, the aperture ring can bend/break that tab. But it varies from lens to lens; some pre-AI/non-AI aperture rings have enough clearance, some don't.
However, all AI/AI-S and newer lenses have cutouts on their aperture rings that don't interfere with that tab.
To answer the OP, I shoot with old Nikon glass all the time. I currently have a Nikkor-S Auto 50mm f/1.4 non-AI on my D60, and I like shooting with my Lester-Dine 105mm f/2.8 Macro on my D700. I also have an older Sigma 15mm f/2.8 Fisheye lens that is fun to play with (although I prefer my rectilinear wide-angle lens for most subjects). Past lenses in my stable have included the Micro-Nikkor 55mm f/2.8 and f/3.5, the 50mm f/1.4 AI, 55mm f/1.2, 50mm f/1.8 AI-S, 35mm f/2.5 AI-S...I'm forgetting a few.