Hey there...all tattoos will fade and settle in with time. It's style, application as well as aftercare that lead to longevity. Tattoo styles like traditional and Japanese with great black lines generally hold well. They don't have to be solid black as black fades, too and application matter.
Aftercare is critical! The sun is a killer of tattoos. Someone recently posted a photo of two 25-30 year old tattoos. One had been exposed to sun without sunscreen (or at least not consistently) while the other never really saw the sun. The tattoo that was covered STILL looked amazing.