Dwarf Fortress will never have proper multiplayer.
Note that you can share saves with other people, where people run succession forts! We have a whole forum section dedicated to this:
http://www.bay12forums.com/smf/index.php?board=14.0God mode might fit in the myth and magic release though.
I'm personally more of a fan of enabling the player, rather than giving them everything outright.
Playing as a 'Demigod' in adventure mode might become more meaningful, but that could be years away.
For now your character just gets to be stronger than your average peasant, and none of those bonuses will make you, the player, any smarter, or more patient.
You already play as the 'observer' in fortress mode.
But there are some really solid reasons not to detail the observer further, in this way.
There is an 'overseer' mode in 47.04 (a backdated version, for now, adventure mode is probably returning to steam before 2024)
It's called adventure mode. The player can raise a small group of workers, gather an axe or two, claim a site, and straight up chop down trees and build on it.
but building sites in adventure mode is a work in progress, aka you can't do everything as per fortress mode.
one notable missing feature is digging, which is the primary reason players play fortress mode almost exclusively.
I'm not sure if mechanisms work at all either! Good luck protecting yourself.