Hi Fuego. In general, I'm happy with the 9-speed on my 2018 EX. At first, it suffered from the hiccups while it "learned how I drive." It now accelerates smoothly but in the last few months, on four occasions has died for five seconds after taking a corner. To me, that's a VERY dangerous problem that should come under the safety issues list.
I hear there is a software tech bulletin to fix a rough shifting problem. After the upgraded software is installed, I'll be back to square one. It will take 500+ miles for the software to re-learn my driving habits. I have not felt any of the rough shifting experienced by others on this forum. I may ask that Honda not do the upgrade. On the other hand, if I refuse, they can void my warranty. It's a no-win scenario.
I drive in ECON mode all the time. Although the acceleration is smooth, it lacks response. Now, everyone will probably say that this is to be expected with ECON mode. The difference is, my wife drives a 2012 CRV, 6-speed in ECON mode all the time. That car is very snappy - almost like an Accord. Then again, it has a Honda transmission.
In conclusion, I think the 9-speeds are basically alright but there have been some major issues with a lot of them. There must be a reason Honda decided to ditch them in favor of their in-house 10-speed for all trim levels. I have misgivings about the long-term reliability. If someone were wanting any 5th generation Odyssey, I'd advise them to choose one with the 10-speed. I test drove a 2020 EX in ECON mode. I was very smooth and snappy. I can't get that response from my 2018 EX.