What's wrong with Sims 3? Sure, it has several lacking features(like carpool still arrives eventhough you set a car and plenty of rabbit holes), but it's still a good game.

DLCs are optional. Too long loading time? You mean while trying to go in the game? It has alot more features and bugs, hence game updates are crucial to avoid the game for crashing. Alot of other games have plenty of updates as well. Whatever you stated, other games have the same issues as well. But about contents not as attractive in Sims 2, then yes, I partially agree because I like the contents in Sims 2 more as well but to each of the game have their own specialty.