People are not fed up of you. You may not get a response due to busyness from professionals. Sometimes people cannot respond in the way one wants, for lots of reasons. That is why having a team of people: a Cpn, a gp, a support worker, family, friends, a job etc can all work together.
You know there is more support available. Step up care and or day hospital have been suggested. Why not try one of them again?
Regarding hurting yourself, that depends. Many people use self harm - not ideal, but as a coping mechanism. But many people do not need to go to the dr's with it. Some do. Yes you are right if you keep presenting with self harm then SS will be notified. Because they will see you reaching out for help if presenting regularly with sh and asking for more help and SS is one of places funding is available. it is not a threat but a source of support. What they do is up to them. But they do not notify them if go for help, and use the correct channels, which is asking your Cpn or gp for step up care or using the day hospital as a place of safety. If you feel you need care after 5 pm can your Cpn involve your family for support? Or ask for assessment for care after 5 pm if you cannot keep safe.
Is it worth asking for a review of your meds as they do not seem to help too much in times of distress - there are some useful other ones out there.
As an aside. Sometime when struggling it can be easy to be trapped in this MH world and helpful to breathe and focus on something else. Such as things we use to distract. I know that is not easy. But is there something you can do for you? Join a club? Go to a class to learn a new skill, lots on in daytime when dd in school and many free. Be a volunteer so focus on something else if not work? Anything to look at life outside of MH terms. Just an idea and obviously not when in crisis and unable to manage.