I just came across a freshly released article on storage path failover behaviour in ESX 4.x. It has been published as a VMware Knowledgebase article. All messages described in this article are shown in /var/log/vmkernel when ESX is performing a failover in case one path goes offline.