Looking at the examples shared here I thought "that's pretty cool, and would be amazing to try, doesn't look creepy at all".

I loaded a portrait of my grandmother taken 60 years ago and it's weird, uncanny valley and very very creepy to see.

It's odd to see a photo you've seen many times of a person you knew so we'll come to life. It's the things that are missing, the small expressions, the details in the way they move the facial muscles, the "life in the eyes". I'm sure if it's of some long forgotten relative it would be interesting to bring a photo to life but not for someone you know.