One of my DH's cousins was in a 90's boy band. They had a couple of hits here but were massive in Europe. These days he does a normal job and is married with a child so has an absolutely avergae life. He still gets recognised walking down the street in places like Paris and Berlin though.
DH's aunt used to run the fan club and was once sent hundreds of pairs of socks by a company as a promotional thing. They were distributed amongst the male members of the family. This is the only tangible benefit DH has seen from his "famous" relative.
I have only met him a couple of times but he seems alright.