Pokémon games in order of werster's favoritism! (Note a '>' denotes how much more favorable the game is compared to the next :))
Pokémon Crystal
>
Pokémon Heart Gold / Soul Silver
>
Pokémon Gold / Silver
>>
Pokémon Red / Blue
>
Pokémon Yellow
>>>>>
Pokémon Black 2 / White 2
>>>>
Pokémon Emerald
>>
Pokémon Black / White
>>>
Pokémon Ruby / Sapphire
>>>>>>
Pokémon Platinum
>>
Pokémon Diamond / Pearl
As for the spinoffs, I don't think it's fair to compare them as the amount of content/replay value is entirely different. On enjoyable level though, they all fall around the same as Emerald, and I love all the ones I've played, including the Stadiums, Snap, Pinball, Mystery Dungeon and Puzzle Challenge.