In "We met at last" "at last" is used to end the sentence which expresses the final result. In "We met at the library" the preposition "at" is used for specific location. In "We met at 5 pm" "at" is used to indicate exact time.