I used to organize the appearances into Cameo, Minor, Medium and Major, covering the categories you mention above. Here is an "almost complete" listing of the Alpha Flight appearances listed into the four categories, a little badly formatted, and a little incomplete but a good starting point. The list ends around 2009 when I started up a different format. All rankings are completely subjective so please no flames about misplaced issues

Cameo
Alter Ego 71
Amazing Spiderman Ann 15(1981)
Amazing X-Men 1
Astonishing Tales 3
Astonishing X-Men 1
Avengers 249 320
Avengers III 1 10 47
Avengers Forever 11 12
Avengers/JLA 3
Back Issue 32
Beyond! 4 5
Bill Mantlo: A Life in Comics No issue #
Black Panther II 42 44
Blackwulf 5
Bullet Points 5
Citizen V: The Everlasting 3
Civil War 7 Chronicles 5 10 Files Opening Shot Sketchbook Poster Book
Classic X-Men 44
Contest of Champions 2
Damage Control III 4
Deadpool and Death Ann 1998
Death Metal 1
Death Metal vs. Genetix 2
Dr. Strange III 1 2 55 56
Encyclopędia Deadpoolica 1
Fantastic Four 266 267 268 367 369 370 405
Fantastic Four Roast 1
Fred Hembeck Destroys the Marvel Universe 1
Gambit and the X-Ternals 1
Generation X 58
G.L.A. 2
House of M 6
Incredible Hercules 126
Incredible Hulk 277 278 279 312 418
Infinity Gauntlet 2
Marvel Age 33
Marvel Atlas 2
Marvel Comics Presents II 8 11
Marvel Fanfare 29
Marvel Holiday Special 1 (1991)
Marvel Knights: Spider-Man 2
Marvel Masterpieces 2
Marvel Masterpieces II 1
Marvel Riot 1
Marvel's Greatest Collections 2009 1
Marvel Spotlight Steve McNiven/Mark Millar 6 Uncanny X-Men 500 Issues 31 Wolverine
Marvel TV: Galactus - The Real Story 1
Marvel Two-In-One 96
Marvel Universe: The End 1 5 6
Marvel: Your Universe 1
Marvel: Your Universe Saga 1
Marvel Zombies - The Book of Angels, Demons & Various Monstrosities no issue #
Mephisto vs... 3
Mighty Avengers 21 23
Moon Knight III 43 57
Ms. Marvel II 1
Mutant X 12 28
Namor 1 36 49
New Avengers 17 18 20 37 45 47
New Excalibur 9
New Mutants II 4
New Warriors 27
New X-Men: Academy X 10 16
Nick Fury's Howling Commandos 6
OHOTMU A-Z Hardcover 2
Marvel Legacy The 1990s
Alternate Universes
Ultimate Universe
Official Index to the Marvel Universe 3
Official Marvel Index to the X-Men II 2 3
Paradise X 0 78 9 11 Special Edition
Punisher Kills the Marvel Universe 1
Quasar 23 24 25 38 50
Ruins 1
One-Shot 1
Sabretooth III 1
Secret Invasion Poster Book No issue #
Secret Invasion: X-Men 2
Secrets of the House of M One Shot
Silver Sable & The Wild Pack 4 5
Silver Surfer Ann 2(1989)
Speed Demon 1
Spider-Man 12
Stan Lee Meets Doctor Strange 1
Strange Tales II 14
Sunfire & Big Hero 6 1
Thor 390 464
Top Ten 8
Ultimate Fantastic Four 23
Ultimate X-Men 70 71 81 88
Uncanny X-Men 138 236 365 379 401 425 437 500 Issues Poster Book
Universe X 2 4 11 X
Warlock Chronicles 2
Warlock & the Infinity Watch 8 18 19
Weapon X II The Draft - Agent Zero 16 19 25
First Class 1
Web of Spider-Man 104
West Coast Avengers 1
What If... II 1 7 23 30 47 101 111
What If? Secret Wars
Wolverine: Enemy of the State
X-Men: Deadly Genesis
What The-?! 1 2 5 6 9
Wolverine II 50 129 145 171 174 176
Wolverine III 31
Wolverine: Days of Future Past 2
Wolverine Saga II No issue #
Wolverine Ultimate Sticker Book No issue #
Wonder Man 13 14 15
X-51 0 12
X-Factor 137 138
X-Man 40
X-Men II
(formerly "New X-Men") 112 140 157 183 188 200
X-Men Alpha No issue #
X-Men Chronicles 1
X-Men Millennial Visions 2001
X-Men Noir 3 4
X-Men Omega No issue #
X-Men Poster Book No issue # (2006)
X-Men: The 198 4
X-Men The End - Book Three:
Men & X-Men 6
X-Men Universe 4
X-Men Unlimited 11 25
Young Avengers 12
Young Guns '09 Sketchbook no issue #

Minor
Age of Apocalypse:
The Chosen 1
Adventures of the X-Men 1
Amazing Spiderman Ann 26(1992)
Amazing X-Men 2 4
Astonishing X-Men 2
Avengers 282 285 288 290
Avengers/JLA 4
Black Panther II 43
Civil War Battle Damage Report
Civil Wardrobe 1
Contest of Champions 1
Darkhawk 31
Deadpool 25
Deadpool: Agent of Weapon X 1
Deadpool: Funeral for a Freak 1
Death Metal vs. Genetix 1
Dr. Strange III 47
Domino 3
Factor X 2
Fantastic Four 220 261 368
Generation X 19
Incredible Hulk 273
Infinity Crusade 1 4 6
Infinity War 1 2 3 4 5 6
Iron Man 195 196
Marvel Comics Presents II 9 12
Marvel Fanfare II 2 6
Marvel Portraits of a Universe 3
Marvel Spotlight Civil War: Aftermath 15
Marvel Vision 19
Marvel Zombies: Dead Days 1
Modern Masters 7
Moon Knight III 41
Mutant X 30 31
New Mutants II 2 7 8
New Thunderbolts 11
Nick Fury's Howling Commandos 2
OHOTMU 1 4 7 8 9 10
A-Z 1 2 3 5 6 8 9 12
A-Z Update 1 2 3 4
A-Z Hardcover 1 3
Deluxe Edition 1 2 6 8 9 10 11 13 14 17 19
Marvel Legacy The 1980s
Master Edition 1 13 17 19 22 26 27
Update '89 1 2 3 4 5 7
Age of Apocalypse
Mystic Arcana
Teams
X-Men
Women of Marvel
Paradise X 2 4 6
Power Pack 9
ROM: Spaceknight 58
Secret Wars II 9
Tales from the AOA: Sinister Bloodlines No issue #
Thunderbolts 43
Ultimate X-Men 62 63 65 69 79 80 97
Uncanny X-Men 147 359 403 416 420 421 431 432 434
Universe X 6 9
Warlock & the Infinity Watch 20
Weapon X 2
Weapon X II The Draft - Sauron 5 6 7 8 9 10 11 17
Days of Future Now 1 2 4 5
Web of Spider-Man 105 Ann 8(1992)
What If... 31 34
What If... II 6 60 79
Wolverine II -1 91
Wolverine III 30 56
Wolverine/Cable: Guts 'n' Glory 1
Wolverine Encyclopedia 1 2
Wolverine: Killing Made Simple 1
Wolverine Origins 33
Wolverine Saga 1 2 3
X-Factor -1 115 117 121 127 130 133 136 141 143
X-Man 27
X-Men: The 198 Files No issue #
X-Men The End - Book Two:
Heroes & Martyrs 1
X-Men: The Manga 13 14
X-Men Unlimited 15

Medium
Astonishing X-Men 3 4
Avengers 286 287 289 291 292
Civil War Initiative 1
Contest of Champions 3
Deadpool: Agent of Weapon X 4
Dr. Strange III 46
Domino 1
Factor X 1
Incredible Hercules 117 118 119 120
Infinity Crusade 2 3 5
Marvel Adventures: Iron Man 11
Marvel Comics Presents II 3
Marvel Saga 1
Marvel Two-In-One Ann 7(1982)
Mutant X 3 29
OHOTMU Wolverine
Over The Edge 2
Peter Porker: The Spectacular Spider-Ham 6
ROM: Spaceknight 56
Saga of the Sub-Mariner 12
She Hulk II 16
Ultimate X-Men 46 47 61 64 94 95 98 99
Uncanny X-Men 392 393 417 418 419 433 505 506 507 Ann1996
Weapon X II 1/2 1 2 3 4 12 13 18
Days of Future Now 3
Web of Spider-Man 106
What If... II 62
What The-?! 7
Wolverine II 36 76 77 83 84 144
Wolverine III 26 27 53 54 55
Wolverine Origins 15
X-Factor 112 113 114 120 122 123 124 125 126 128 129 132 134 135
X-Infernus 1 2 3 4
X-Man 28
X-Men II
(formerly "New X-Men") 113 163 164
X-Men: Age of Apocalypse One-shot 2
X-Men: Divided We Stand 1
X-Men The End - Book One:
Dreamers & Demons 6

Major
Avengers 272 293 321 322 323 324
Classic X-Men 16 26 27 45
Crystar 11
Deadpool 1
Death Metal 2
Incredible Hulk 272 313 Ann 8(1979)
Iron Man 195
Machine Man 18
Marvel Age 2
Marvel Comics Presents 51 52 53 92 99
Marvel Fanfare 28
Marvel Team-Up Ann 7(1984)
Marvel Two-In-One 83 84
Maverick 3
Namor 61
New Avengers 16
New X-Men: Academy X 13
Nick Fury, Agent of S.H.I.E.L.D. 32
Northstar 1 2 3 4
Omega Flight 1 2 3 4 5
Power Pack 10
ROM: Spaceknight 57
Sabretooth III 2 3 4
Sabretooth: Back to Nature 1
Secret Defenders 11
Secret Wars II 4
Uncanny X-Men 109 120 121 139 140 355 405 414 415 422
Weapon X II The Draft - Wild Child 22
What If... II 59
Wolverine II 35 37 92 95 110 142 143 172 173 179 180
Wolverine III 25 28
Wolverine: First Class 5
X-Factor 116 119 142
X-Men II 189 190 Ann (2007)
X-Men/Alpha Flight I 1 2
X-Men/Alpha Flight II 1 2
X-Men Classic 46
X-Men Unlimited 45
X-Men Unlimited II 12