I've yet to see a discussion based on an attack and then working from there... so here is my attempt :-) I should note that this is not an analysis for "who is the best rapid spinner". The purpose here is to list all the possibilities of rapid spinner and discuss them. There seems to be quite a selection of rapid spinners so just sticking to the standard may not be the best thing for your team.
http://www.serebii.net/attackdex-dp/rapidspin.shtml
Rapid Spin. Physical
20 Base, 40 PP, Normal
Reason for using it: With only 20 base power, the only good reason to use this attack is to get rid of spikes, stealth rock, and toxic spikes.
Fully Evolved Pokemon who can learn it
Blastoise
Sandslash
Starmie
Forretress
Donphan
Hitmontop
Torkoal
Claydol
Pokemon with Rapid Spin as an Egg Move
Tentacruel
Cloyster
Hitmonlee
Hitmonchan
Kabutops
Delibird
Armaldo
Pokemon who resist Stealth Rock.
Sandslash
Donphan
Hitmontop
Claydol
--
Hitmonlee
Hitmonchan
Pokemon weak to stealth Rock (BAD for a Rapid Spinner)
Torkoal
---
Cloyster
Delibird
Armaldo
Pokemon immune to spikes
Claydol (Levitates)
---
Delibird (Flier)
Pokemon immune to toxic spikes (not including the above list)
Forretress (Steel Immunity)
---
Tentacruel (Poison Immunity)
With that list made, first I feel a discussion of what a "good" rapid-spinner can do. A Good rapid-spinner can switch in and take the hit from spikes/stealth rock/toxic spikes as well as the opponent. Second, they must either be fast enough to rapid-spin or defensive enough to survive another hit. For this reason, Delibird, even with its immunity to spikes/toxic spikes, is perhaps the worst Rapid Spinner on this list. With a 4x weakness to Stealth Rock, low defenses, low HP and sub-par speed, it most likely won't even get the rapid-spin off.
As for what a "good" rapid spinner is, we only have to look at the standards. Starmie and Donphan. Donphan specifically has 90 HP and 120 base defense. While slow, it has no 4x weaknesses and can probably survive the switch in and spin. Donphan's specialty is here. A decent amount of HP, high defense, high attack, and low speed (worthy for trick room but still useful without it).
However, as a ground pokemon, Donphan is weak to ice, water and grass. So it is not the appropriate pokemon in a team weak to those already. Instead it might be more appropriate to choose say Hitmontop, who would not contribute to water/ice/grass weaknesses in your team.
EDIT: I was made aware of another fact. Rapid Spin must actually _hit_ the opponent for it to actually work. And because of this fact, ghost pokemon can simply sit there and prevent the rapid spinner from doing his job. On page 2, Deck Knight lists 4 common pokemon that take advantage of this fact: Gengar, Mismagius, Dusknoir, or Spititomb, the latter two having no weaknesses outside a pokemon with Scrappy or "Foresight". So as an additional requirement, good rapid spinners will be able to do something in the case where a ghost pokemon switches in.
As a note, here are Starmie's and Donphan's analysis pages.
Starmie
Donphan
A rundown of misc. interesting stuff in potential Rapid Spinners.
Blastoise -- Decent Sp. defense and Defense. Yawn and Mirror Coat
Sandslash -- "Sand Veil", decent attack/defense. Swords dance, Brick Break, Night Slash, Slash, Gyro Ball + below average speed.
Starmie -- Checkout the analysis.
Forretress -- Excellent bug/steel typing, high defenses, decent HP, "Sturdy", Explosion!, STAB Gyro Ball + very very slow.
Donphan -- Checkout the analysis
Hitmontop -- Intimidate or Technician. Both excellent but Intimidate is probably better for a Rapid Spin set. Hi Jump Kick, Mach/Bullet Punch + Technician boost, Triple Kick, Aerial Ace + Technician
Torkoal -- Sucks. Lol. But has above average defense and is possibly the slowest pokemon in the game at 20 speed. (slower than SlowBro and Snorlax). One of the few pokemon to learn Lava Plume...
Claydol -- Explosion! Immune to Spikes/Toxic Spikes and resists Stealth Rock. Above average defenses on both sides of the spectrum.
-----
Tentacruel -- 100 base speed, Toxic Spikes, Giga Drain, Poison Jab, Swords Dance. 120 base Sp. Defense.
Cloyster -- Huge Defenses at 180 base! But only 50 base HP to back it up. 4x resist to the ever present Ice attack. Spikes and STAB Ice Beam.
Hitmonlee -- Endure/Reversal combo, Blaze Kick, High Jump Kick, Close Combat, Bullet/Mach Punch and nice 120 base Attack. Decent 110 Sp. Defenses behind only 50 base HP.
Hitmonchan -- "Iron Fist" raises punch damage by 20%. Thunder/Ice/Fire Punch, resisted by no one IIRC. Like hitmonlee with 110 Sp. Def behind 50 base HP.
Kabutops -- "Swift Swim", 105 base Defense and 70 base HP. 115 Base Attack. Slash, Night Slash, X-Scissor.
Delibird -- You'll surprise the foe with a NU pokemon using rapid spin :-/ If you really wanted, you probably can get a free switch in on a "Spore" with Vital Spirit.
Armaldo -- Swords Dance + high attack, decent 100 defenses with 75 base HP.
Okay, thats that.
http://www.serebii.net/attackdex-dp/rapidspin.shtml
Rapid Spin. Physical
20 Base, 40 PP, Normal
Reason for using it: With only 20 base power, the only good reason to use this attack is to get rid of spikes, stealth rock, and toxic spikes.
Fully Evolved Pokemon who can learn it
Blastoise
Sandslash
Starmie
Forretress
Donphan
Hitmontop
Torkoal
Claydol
Pokemon with Rapid Spin as an Egg Move
Tentacruel
Cloyster
Hitmonlee
Hitmonchan
Kabutops
Delibird
Armaldo
Pokemon who resist Stealth Rock.
Sandslash
Donphan
Hitmontop
Claydol
--
Hitmonlee
Hitmonchan
Pokemon weak to stealth Rock (BAD for a Rapid Spinner)
Torkoal
---
Cloyster
Delibird
Armaldo
Pokemon immune to spikes
Claydol (Levitates)
---
Delibird (Flier)
Pokemon immune to toxic spikes (not including the above list)
Forretress (Steel Immunity)
---
Tentacruel (Poison Immunity)
With that list made, first I feel a discussion of what a "good" rapid-spinner can do. A Good rapid-spinner can switch in and take the hit from spikes/stealth rock/toxic spikes as well as the opponent. Second, they must either be fast enough to rapid-spin or defensive enough to survive another hit. For this reason, Delibird, even with its immunity to spikes/toxic spikes, is perhaps the worst Rapid Spinner on this list. With a 4x weakness to Stealth Rock, low defenses, low HP and sub-par speed, it most likely won't even get the rapid-spin off.
As for what a "good" rapid spinner is, we only have to look at the standards. Starmie and Donphan. Donphan specifically has 90 HP and 120 base defense. While slow, it has no 4x weaknesses and can probably survive the switch in and spin. Donphan's specialty is here. A decent amount of HP, high defense, high attack, and low speed (worthy for trick room but still useful without it).
However, as a ground pokemon, Donphan is weak to ice, water and grass. So it is not the appropriate pokemon in a team weak to those already. Instead it might be more appropriate to choose say Hitmontop, who would not contribute to water/ice/grass weaknesses in your team.
EDIT: I was made aware of another fact. Rapid Spin must actually _hit_ the opponent for it to actually work. And because of this fact, ghost pokemon can simply sit there and prevent the rapid spinner from doing his job. On page 2, Deck Knight lists 4 common pokemon that take advantage of this fact: Gengar, Mismagius, Dusknoir, or Spititomb, the latter two having no weaknesses outside a pokemon with Scrappy or "Foresight". So as an additional requirement, good rapid spinners will be able to do something in the case where a ghost pokemon switches in.
As a note, here are Starmie's and Donphan's analysis pages.
Starmie
Donphan
A rundown of misc. interesting stuff in potential Rapid Spinners.
Blastoise -- Decent Sp. defense and Defense. Yawn and Mirror Coat
Sandslash -- "Sand Veil", decent attack/defense. Swords dance, Brick Break, Night Slash, Slash, Gyro Ball + below average speed.
Starmie -- Checkout the analysis.
Forretress -- Excellent bug/steel typing, high defenses, decent HP, "Sturdy", Explosion!, STAB Gyro Ball + very very slow.
Donphan -- Checkout the analysis
Hitmontop -- Intimidate or Technician. Both excellent but Intimidate is probably better for a Rapid Spin set. Hi Jump Kick, Mach/Bullet Punch + Technician boost, Triple Kick, Aerial Ace + Technician
Torkoal -- Sucks. Lol. But has above average defense and is possibly the slowest pokemon in the game at 20 speed. (slower than SlowBro and Snorlax). One of the few pokemon to learn Lava Plume...
Claydol -- Explosion! Immune to Spikes/Toxic Spikes and resists Stealth Rock. Above average defenses on both sides of the spectrum.
-----
Tentacruel -- 100 base speed, Toxic Spikes, Giga Drain, Poison Jab, Swords Dance. 120 base Sp. Defense.
Cloyster -- Huge Defenses at 180 base! But only 50 base HP to back it up. 4x resist to the ever present Ice attack. Spikes and STAB Ice Beam.
Hitmonlee -- Endure/Reversal combo, Blaze Kick, High Jump Kick, Close Combat, Bullet/Mach Punch and nice 120 base Attack. Decent 110 Sp. Defenses behind only 50 base HP.
Hitmonchan -- "Iron Fist" raises punch damage by 20%. Thunder/Ice/Fire Punch, resisted by no one IIRC. Like hitmonlee with 110 Sp. Def behind 50 base HP.
Kabutops -- "Swift Swim", 105 base Defense and 70 base HP. 115 Base Attack. Slash, Night Slash, X-Scissor.
Delibird -- You'll surprise the foe with a NU pokemon using rapid spin :-/ If you really wanted, you probably can get a free switch in on a "Spore" with Vital Spirit.
Armaldo -- Swords Dance + high attack, decent 100 defenses with 75 base HP.
Okay, thats that.