What is the best product to use with a curling iron?

my hair is super-duper straight and when ever I curl my hair it stays for like 30min. I use tresemme curl activator spay thermal creations but it makes my hair stiff any suggestions?