Yes, asserting RESET# signal LOW for at least tRP time (after VIO powered up) will cause device reset. RESET# causes the same initialization process as is performed when power comes up and requires tPU time. So, device will be in standby state after reset operation. More details about RESET# operation is available in our datasheet (https://www.cypress.com/file/448601/download , page 9).
Thanks and Regards,