I think the OP asked for personal experiences. I used to use homeopathy, and at one point I lived with a homeopath who was both practicing and teaching homeopathy.
It has never worked for me. Regular homeopathic treatments did nothing at the beginning of a very serious chronic illness, which I still have. Instead, I got worse and worse. Later, I was given it for an ear infection ( by a practicing GP, no less, with daily, personalised remedies). I endured about a week of increasing agony with him saying’ it should be getting better by now….wait, I’ll give you a stronger ( ie more dilute) remedy’ before I finally gave up and went to my usual GP. He sent me straight off to ENT , same day, where they cleaned out my ear and popped in some antibiotics . Instant relief, but I have permanent hearing loss in that ear and sometimes wonder…
Over the years, through reading and also remembering my homeopath friend, I began to understand it more. The ‘in depth’ consultation looking for the ‘real causes’ of your ailment is actually, in part, an exercise in fitting you into one of a number of ‘constitututional’ remedies….the theory being that, because ‘like cures like’ , giving the ‘constitutional’ is therapeutic. Feel better at the seaside? You may well be a Nat Mur. Nat Mur is….seasalt.
I won’t go on about the theory behind homeopathy, enough to say that in my opinion it’s based on magical thinking. Magical thinking is far more common than we realise, and is something to which nearly all of us are susceptible. The placebo effect is also very mysterious and powerful.
Most people tend to respond well to being given lots of time to talk about themselves, and sympathy. This is what you get in a consultation with a homeopath, and is probably the true therapeutic mechanism of homeopathy.