It’s a name, like 10,000 others. Nothing special about it, except that it’s short.
It does get bastardized a lot. I have seen it as Aimee, Ammee. once as Aymy. So people can screw up a spelling of a three letter word.
In my life, I have known probably 15–20 Amys. One was a very good friend. Most were acquaintances or work colleagues. One was a real bitch.
I have never slept with anyone named Amy.