I haven't used spray before but have done in the past solid and gel (roll on or stick form). Solid is what I've stuck with the most and the invisible solid. I think the scent I normally get is like light and fresh or something like that. I try not to get ones that are too strong in perfume smell.
Those who use spray keep an eye out as those have been going through recalls last year and this year due to harmful contaminants. I think hair spray was as well can't remember.
Deodorant is best applied at night.