It was basically the 3D equivalent of Geocities. You could wander for hours, looking at the cool little houses and weird displays people had built. You could even do simple scripting with keyframes for animating objects by toggling their visibility. :)
It was so cool, and I even ended up buying a little AWLD stock. The market imploded of course, and the people running it apparently did some scummy things (see Shamus Young's accounting here: http://www.shamusyoung.com/twentysidedtale/?p=13720 ).
The only thing really missing was modeling; to solve this, you'd run across giant prefab yards, and then write down model names. Mars had a sort of boneyard for this purpose.
They also did kinda-cool tie-ins with other media, like a world for The 13th Floor and the X-Files movie. I miss that sense of "Oh man, this is the future!".
Perhaps once VR goes fully retail we'll see world creators like this become popular.
It seemed to follow exactly the path second life went, except with the diminished number of people that were on the internet at the time: very high initial interested (the "wow - 3d internet factor") and very little engagement after that.
I really thought 3d web would be a thing. :)
[1] http://activeworlds.com
[2] https://osantana.me/vintage/borolandia/artigo03/index.html (article in portuguese, pics of a brazilian AW server back from 2000)