Yes. Our kids like to play Luigi’s Mansion with their aunts and uncles, and we have played Animal Crossing with friends. It’s only around $30 a year, IIRC, so it’s worth the cost for us.
I got a membership to play Switch Sports online because basically the only interesting feature of the game. I got to top ranking in Badminton then lost interest real quick.