How long can i expect to have fun with this game, and does it still entertain after the campaign is finished?

The campaign alone will take many, many hours. Then there is a large base of excellent player created campaigns. After that, you can replay the same scenarios again and again with different strategies, difficulties, etc. If you like city builders, its effectively endless.