What are all the notable fishing spots with Super Rod in Crystal?

Question

So far I've caught good Pokemon with the super rod but I haven't explored every map using the super rod. Where do you recommend using the super rod?

A notable fishing spot might have Pokemon that can't be encountered elsewhere, hold useful items, have high-level Pokemon, etc.

Comments

How do you define "good Pokemon"?

---

subjective?

---

Do you mean anything that isn’t a magikarp and tentacool?

---

I have changed the description. Hopefully it gives a basis for an answer. This is not a perfectly well defined question but there should be enough guidance for an expert to give relevant advice.

---

I don't think you can fish items in Crystal.

---

I think Fizz meant Pokemon that hold items, key being luvdisc I bet

---

I did a pretty major edit on my answer.

Answer 1

This answer assumes you agree with Fizz's edits. If you don't, please tell me and I'll convert this answer to a comment.

In Crystal, there are only 10 fishing encounter tables.

Cherrygrove City, Olivine City, Cianwood City, Dark Cave (B2F), Route 34, Route 40, Route 19: Krabby, Kingler, Staryu, Corsola
New Bark Town, Olivine City (harbor) Pallet Town, Vermilion City, Cinnabar Island, Route 41, Route 27, Route 26, Route 20, Route 21: Tentacruel, Shellder, Chinchou, Lanturn
Dark Cave, Union Cave, Slowpoke Well, Mt. Mortar, Tohjo Falls, Silver Cave, Route 42, Route 24, Route 25, Route 9, Route 10: Goldeen, Seaking, Magikarp
Violet City, Ecruteak City, Blackthorn City, Viridian City, Ruins of Alph, Ilex Forest, Route 30, Route 31, Route 35, Route 43, Route 44C, Route 28, Mt. Silver (exterior), Route 22, Route 6: Poliwag, Magikarp
Route 32, Route 12, Route 13: Tentacool, Magikarp, Qwilfish
Lake of Rage, Fuchsia City: Magikarp, Gyarados
Whirl Islands: Krabby, Kingler, Horsea, Seadra
Route 45: Magikarp, Dratini, Dragonair
Dragon's Den: Magikarp, Dratini, Dragonair
Route 32 (Qwilfish swarm): Qwilfish
source

These are the items they can hold when you encounter them.

Shellder: pearl (common), big pearl (rare)
Horsea: dragon scale (rare)
Seadra: dragon scale (rare)
Staryu: stardust (common), star piece (rare)
Dratini: dragon scale (rare)
Dragonair: dragon scale (rare)
source