We are talking about simple sentences.
Have indications a period and ends so there is completion.
Grammar doesn't exist in isolation, Talk. Even the simple sentence,
I've lived here for ten years.
doesn't absolutely indicate a completion. It might, as in,
[Said on the day when the lease has expired and the person no long has possession of the residence] I've lived here for ten years, but now it's time to move on.
[Can't the present perfect continuous, 'have been living', substitute here, in the speaker will continue to live "here"?]
Even though there is completion, this particular present perfect is the present perfect of current relevance/importance.
There are some differences between NaE, AuE and BrE on this use, perhaps that's where we see things a bit differently.
NaE is likely to use the past simple, "I lived here ... " unless the speaker wants to make the past action current to now, or the past action hold some "extra degree of importance.