Before I switched to clinical strength deodorants (long days that often involve sport in the middle of a workday!) I swore by Mitchum Roll On, and my preferred variant was the 24 hour one.
On top of being easily affordable, and distinctive with the green packaging, I found that Mitchum roll on was really effective, and stopped both wetness and odour. The scents were inoffensive (in comparison to other brands in particular) - I don't feel like scent should come from your armpits, personally and prefer my deodorant mostly unscented.
One issue I had with this product repeatedly was drying time, and in the end I resorted often to my favourite trick: popping the hairdrier on cool and using it to dry deodorant :p
If I were on a budget I'd happily go back to using this range, but feel that the clinical strength ones are right for me at the moment.
One of the best deodorants I have ever used, definitely keeps you smelling nice all day. Would highly recommend this product. Especially if the deodorant you are currently using doesn't last all day. I have tried a few different ones and this is definitely one of the best