As long as you don't come across any bad mannered players the experience can be classified as quite enjoyable, especially if you enjoy the normal offline game. You simply have more people with who you can interact
The Sims 2 is an exclusively single player game and does not have online functionality. Therefore it is impossible to appraise how fun such an experience might be.