Spiritual direction has been a wonderful experience for me.
My SD is also my confessor, so we talk a lot about sin & temptation, and how to avoid it. We talk about how God is working in my life, how my prayer life is going, etc.
The best analogy I have ever heard is that a SD is like a mirror. Their job is to reflect back to you what you are saying, in a way that helps you to see God working in all things.
Not every priest is cut out to be a spiritual director, it is really a charism that some have, some do not. My best advice to find one is to contact the vocations office or the adult faith formation office for your diocese. Or, if you have any religious houses in your area, you may want to try them to.
Good luck in your search and peace be with you on your journey!!