Firstly, on behalf of university academics, I'm very sorry you are being subjected to that kind of talk about your performance. What you are describing is not constructive criticism, and it is not a good way to give feedback to a student (even if their work is actually terrible). It sounds like your advisor is acting out of frustration, and has lost the perspective necessary to give constructive assessment and advice in the way he should. Thus, at a minimum, you should find yourself a new advisor who can give constructive criticism on your work. If you have trouble finding someone else to supervise you, you should speak to the Graduate Program Coordinator (and then possibly the Head of Department, if necessary) about the criticism you have been receiving, and ask to have someone else allocated to you. Aside from any deficiency in your own work, that kind of interaction shows a deficiency in the supervisory abilities of your supervisor.
Now, while the feedback you are getting is certainly not how it should be framed, it is nonetheless indicative that your work is not of sufficient quality at the moment. You should grit your teeth and take that feedback on board, and rationally assess its factual validity, setting aside the rude aspects of the way it was delivered. You will need to assess whether or not you have the skills to continue your program effectively under another supervisor, or whether you need to do some bridging work first. It would benefit you to get a second opinion on this from another academic in your area if possible, to identify any present deficiencies in your work. I certainly disagree with the view that "there is no scope for growth" in your work --- that is essentially antithetic to the very notion that education is possible.
My advice in this situation would be to speak to your supervisor and Department Head to start the process of finding another supervisor, and see if you can get a second opinion on where you stand in your program, (e.g., are you behind, and if so, how much), the quality of your work, and how you can go about developing your skills to complete your program. Higher-degree candidature has periodic formal performance reviews, so you will also be able to get some feedback at your next review, but you should not wait until then to act. After considering how you are travelling, relative to requirements to complete your program, you will be able to make a decision about whether you should continue or not.
Finally, try not to let this kind of feedback negatively affect your own assessment of your own quality as a person, or shatter your confidence. A person is not at all "worthless" or "good for nothing" merely because they are struggling ---or even totally unable--- to complete a higher-degree candidature at university. Higher degree candidature is difficult, and it takes a lot of time and skill-development. It is not suitable for everyone, and even for those that manage to do it, they always start off from a place of incompetence and progress gradually towards competence. (That is the whole reason we have education programs over years and years.) We all start off learning to colour with crayons at pre-school, and it is a long and arduous journey through to the upper-echelons of tertiary education.