As far as PS4 is concerned, I can say with 100% certainty that user mods will not be possible. Sony would never allow it, the risk of something going wrong (maliciously or by accident) with the system is unacceptable to them. That said, the console edition might have some tweaks compared to the PC edition (initially or through updates) to make certain tasks easier or console-friendly, potentially removing the need for some of the essential mods. Or not, in which case everything I'll achieve will be far more rewarding.