I used to love it in the early 1990s when I used to listen to David Lee Roth, Mr Big and Stu Hamm. I got quite decent at chucking in bits to the sort of funk / rock band I was in a the time (it was the early 90s, right?).
Ive written a few nice little bass tunes with tapped harmonics etc, but not the whole super fast shredding sort of tapping anymore.
Doesnt really fit in to anything beyond that slim genre, and I’ve never needed to use it since, er, 1993?