Is this possible like with netflix? And does everyone have their own playlist library? Or mixed everything up
There's https://www.spotify.com/de/family/, it's something like that. But only works if you really have the same address, otherwise Spotify will sometimes block the accounts again. But then you have up to six separate accounts.
I can't confirm that with the same address. We have six accounts at three addresses. And it runs like clockwork.