I think a tripod is more important for close-ups.
Any good digital camera will work.