I believe i can self-host a matrix client but no idea how well it will work with people currently having notifications by discord bot on their phone

In my opinion discord is not yet enshittified enough for these problems to be easily solved. Give it a couple more years, if matrix gains just a bit more traction, the scaffolding to do stuff like that will be worked out.