When im driving my kids to school I tend to shift at 6200rpms... VTEC all the way...and this is in a school zone....Yeah!!!!!......just kidding.
I usually mash the gas when entering the highway and my auto shifts at like 4000.....I try not to gun it since .........its only a 4cyl and not a race car.. = (...
On my VW I shift at around 2500-3000rpms. thanks to the turbo..I shift before it really kicks in.
Hondas lack torque so I would say its safe to rev a bit higher.