Automatic Shifting

I’ve been looking at getting a new Honda with automatic transmission. I see that most of the automatics have an switch that gives you the option of automatic shifting or shifting manual with the push buttons. Is this just a gimmick, or do people actually use these. If you have an automatic Honda, what % of time do you use the manual shifting mode? Or do you always just drive in auto mode?