I have some experience with these. I would say what to use would depend on what you want to do. For example if you are developing a sensor or relay or valve controller for an industrial client, better to use Modbus, profiNet, profibus, devicenet etc. If your are developing for lighting applications CAN, DALI or DMX may be a good choice. For automotive CAN is the obvious choice.
CAN was originally developed by BOSCH for automobile buses, that are prone to interference. CAN is a very robust bus and quite fast. If you are looking to develop something completely new, your own network, you can go with CAN. We ourselves have started using CAN. But if you want to be more compatible in the industrial segment stick to MODBUS, PROFIBUS.