Repeat dropper and failure at multiple community colleges. Is there no hope for me?
If you succeed now in community college, the previous failures are unlikely to be a factor.

The point of the admissions process is to determine whether you are capable of succeeding in a university now, not ten years ago.  Your recent track record will demonstrate your present ability best and will be weighed most heavily.

Plus, you have a very plausible story for why things are different now: you have matured, and now have a motivation and direction you didn't have previously.  When you do apply, you should highlight this story.

I don't think there will be a problem here, assuming you succeed now (best of luck to you).

If you do attend the same institution, you should apply for an academic renewal, so that your previous failure doesn't drag down the GPA.

At other institutions, don't worry about it.  You may need to include a transcript for them, but the old GPA will be considered ancient history and will probably not make any difference.