I'm sorry that you had an upsetting interview experience!

There are some "standard" job interview questions that can be asked of anyone. "What's your greatest weakness?" is number four of the top ten most common according to Coursera.

For a few years I was on an interview team. I got to experience the other side of the interview. I found it nerve-wracking because I had to discuss what I thought of the candidate afterwards. Usually we ask the candidate to clarify some aspect of their resume. But occasionally we'd revert to one of the common questions. I'd usually ask, "Where do you see yourself in five years?"