For me, nothing beats the opening to Rush's 1980 album, Permanent Waves, and being instantly pulled in with the flurry of a guitar-riff that is "The Spirit of Radio," an absolute banger track that sets the mood for the rest of the album.
What other albums have the perfect opening song?
[Note: No long, multi-part suites, especially not ones that take up the entire first-side of an album]