Can you Benefit from Dual-CPU Motherboards in a Non-Server Environment?

Can you Benefit from Dual-CPU Motherboards in a Non-Server Environment?