I've played the earlier sims games on PC, like when The Sims first came out in the 90's and have had most of the expansion packs up until making magic.
On console, each game isn't considered an expansion pack, that's a PC term. As mentioned, each game is a stand alone game. The games are also a toned down version of the PC version so you get less stuff and can do less, but they can still be fun in their own way. They also don't make as many console versions as they do for PC, like the expansion packs for PC. I believe for console you have The Sims, The Sims 2, The Sims 3, The Slms 3 Pets, and earlier you have I think it's called Urbs: The Sims In The City (or something like that), which I read was horrible.