Honda automatic trannies are very fragile, so I wouldn't deviate from what the manual says if you want the tranny to last you any decent amount of time. I highly recommend Honda genuine fluid for all Honda trannies.
The power steering fluid on most cars can be ATF, but with Hondas, it must be formulated to work in a Honda steering rack. Most auto parts stores will have fluid made for Honda racks, so you don't need to go to the dealer to get some.
The coolant and brake fluid are fine to be substituted with non-OEM fluid.