While I miss to some degree Dragon and Dungeon, both fine magazines in their own right, these days I find myself remembering and looking back most fondly at the Games Workshop (GW)-published White Dwarf magazine, "the voice of British adventure gamers."
Eh, you role-players say? Doesn't GW still publish White Dwarf every month? For the record, they do. But for me, the magazine died roughly around issue #100, when it became a mouthpiece for GW's profitable miniatures wargames line.
Tabletop Heroes: A regular column devoted to minatures painting. It contained lots of great advice not only on how to paint, but also caring for figures, building terrain, castles, and dungeons out of household products, and more. The color illustrations of finished figures were great, although I was left with an inferiority complex when comparing these to my own.
Treasure Chest: A great column of odds and ends, neat little ideas for treasure and devices, alternative rules, and more that you could pick up and drop into your game. Examples: The dungeon cart (a practically-designed, easily-transportable cart specifically designed for underground adventures), drowning rules, the sword of thunder (a +2 intelligent sword that allowed the user to deflect lighting bolts and absorb their charges into the blade; the clear pommel would glow blue when so charged), dragon shields (magic shields made of dragon scales/hide that confer complete protection from that dragon type's particular breath weapon), hints for creative spell uses, halfling-specific magic items, nunchucks in Runequest, and much more.
British style and humor. The letters and reviews in White Dwarf were full of that particular brand of British wit that I find endearing. Example: Issue #63 reviewed XL1: Quest for the Heartstone, a notoriously bad D&D module, with the following: Quest for the Heartstone was at first reading no more than a sales exercise for AD&D Action Toys, and is very reminiscent of everyone's first dungeon: a collection of randomly placed monsters with a random selection of Good Guys going off after some magic item and having to hack through them...my favorite is 'You may use the five-headed Hydra Bendable Monster for this encounter.'
Fun comics. My favorites were Groo, a little three or four-panel strip about the sick adventures of a thick-skulled goblin, and Thrud, which followed the adventures of a massive-bodied, small-headed barbarian that invoked all the worst Conan cliches.
Crunch-less articles. One of the reasons I stopped buying Dragon was that it seemed in the latter days too preoccupied with "crunch," aka. new prestige classes, feats, magic items, etc. This stuff gets real old, real fast. White Dwarf had its share of crunch, but devoted lots of page space to thoughtful columns and features about topics like roleplaying characters after death, discussions on how fast or slow to level, how to colorfully roleplay clerics in D&D, how to create campaigns and worlds with depth and versimilitude, etc.
Sure, White Dwarf wasn't perfect. In particular, my eyes glazed over at "Microview," a bi-monthly computer column about how to write computer programs to aid your tabletop RPGs (issue #50, for example, contained the code for creating a Taurus III striker vehicle, using BASIC language on a TRS-80. Yuck.). But nevertheless, White Dwarf was an invaluable resource from the heyday of RPGs and a vanished member of a species of magazine that, sadly, is all but extinct.