The effect will vary from lens to lens. Older lenses are often ideal for this use as they usually have an adjustable aperture ring. This is an inexpensive way to try out macro photography and often a great way to make use of your older manual lenses.
eBay