Should I finish my current not so good PhD research or start a new PhD in a much better university with a much better PhD adviser?
I see this as a question about whether you should choose to attend a fully funded PhD program with an advisor you like, or to continue on a more expensive, less supportive path. If it's legitimately true that you would be taken on at the new university, that's a great opportunity.