Yes, it can. The Get-Stat cmdlet that is present in PowerCLI v4 returns a value for all instances and one aggregate value.
The instance field contains the CPU-id for the per core values and an empty string for the aggregate value.
With a script like this you get all the CPU instances.
$stats = Get-Stat -Entity (Get-VMHost <ESX-hostname>) -Stat cpu.usage.average -Realtime -MaxSamples 1
$stats | where {$_.Instance -ne ""} | %{
Write-Host "Core" $_.Instance "avg" $_.Value
}
Note that when you have multiple CPU blocks (for example 2 quad-core processors) the instance numbering will be sequential (0,1,2,3,4,5,6,7...)
The consecutive numbers belong to one processor block.
You can use the HW info to find out what type of processor is in the ESX host.