Since the OP asked for 2 Great Consecutive Albums, I will stick to that(or 3 Consecutive Albums in some cases) in my list below, but certainly a few Music Artists have released 4-6 Great Consecutive Albums, including Stevie Wonder 5 Albums from 1972-1976, Roxy Music First 5 Albums from 1972-1975, which were more Art-Rock compared to their Final 3 Albums, The Brothers Johnson First 5 Albums from 1976-1981, Slave First 6 Albums from 1977-1981, Magazine First 4 Albums from 1978-1981, The Cars First 4 Albums from 1978-1981, The Police last 4 Albums from 1979-1983, The Gap Band 5 Albums from 1979-1985, Echo & The Bunnymen First 4 Albums from 1980-1984, Siouxsie & The Banshees 6 Albums from 1980-1986, Public Enemy First 4 Albums from 1987-1991, Red Hot Chili Peppers 6 Albums from 1989-2006, Doves 5 Albums(Their Entire Discography so far with their First 4 Albums released 2000-2009 then after a long break, they reunited for The Universal Want Album released in 2019), Elbow First 4 Albums from 2001-2008, Suede Last 4 Albums from 2013-2022 after they reunited, which is close to their First 3 Albums from the 1990s, Spiritualized First 4 Albums from 1992-2001, MUSE First 4 Albums from 1999-2006(MUSE has been the Best Live Rock Band the past 23 Years), Fleetwood Mac 5 Albums from 1975-1987, Joe Jackson 5 Albums(not including Soundtracks) from 1982-1991, Porcupine Tree 5 Albums from 1993-2000, Miles Davis 8 Albums from 1968-1972(a mix of his 2nd Quartet Later 4 Albums with his Fusion 4 Essential Albums) and Peter Gabriel 6 Albums from 1980-2002(I am including the Passion Soundtrack, which I think is as great as 3-Melt, but have not spent enough time yet with I/O to determine how great I think it is, despite having listened to each Song released every Full Moon last year, as I wanted to get familiar with them prior to seeing his Tour Stop in Philly last September, which meant I missed the The Backyard Brawl, that was played that same nite, but watched it 2:00AM as had it recorded).
Talking Heads-Their Entire Discography from 1977-1988.
The Smiths-Their Entire Discography from 1984-1987
I also wanted to mention That the SDE Exclusive BluRay(with Atmos & 5.1 Remixes) Release of Tubular Bells had me discovering the Music of Mike Oldfield, as I had not even heard Tubular Bells before streaming it last year when deciding to buy the SDE BluRay as loved the Music. I also bought the 50th Anniversary CD and the Japan SHM CD think was from around 2013/2014 and utilized the Original UK Tapes for the Mastering. So, I have been doing a deep dive on most of his Albums, at least up through Crises(1983) and Return to Ommadawn(2017), although several of his fans rank Amarok(1990) & Tubular Bells-II(1992) as really Good Albums, so I plan to stream them soon.. I think I would at least rank his First 4 Albums(Tubular Bells, Hergest Ridge, Ommadawn & Incantations) as Great Albums, so will add him to Music Artists above with at least 4 Consecutive Great Albums.
A few people here mentioned The CURE, and I saw them last Summer, when they played several New Songs from a yet Unreleased Album, but I was able to get familiar with them first watching Earlier Tour Stops, which were uploaded on YouTube and get the Setlist from the SetlistFM Website. Anyways, a few Consecutive CURE Albums make my list.
I will attempt to list my Pair of Albums generally from Oldest to more Recent Releases, except when having multiple listings for a few Music Artists, but I am not good on knowing specific years of release during the 1960 & 1970s, so might be off a little on the correct order for earlier years.
Also, I love P-FUNk(all related Albums, which I own over 55 CDs), but every Album has a few Weak Songs, so do not consider their Albums Great overall, yet essential in my CD Collection because they still consist of at least 60%-80% of Great Songs. Same problem for Pink Floyd, although I prefer their Earlier Psychedelic-Rock & Space-Rock Songs, like the 4 Live Songs on Ummagumma. Also, I think Elton John had 3 Great Albums(Self Titled bring my Favorite, and Madman Across the Water & Captain Fantastic), but there were other Albums released in between those 3 I mentioned.
I have several David Bowie from 1970-1980 listed below, although some of my Favorite Bowie Albums are from 1993-2016, but just not consecutive(the First Bowie Album I bought was Black Tie, White Noise in 1993, which by coincidence was the year when Suede released their Debut Album, which was similar to the Bowie Glam-Rock Early 1970s Music).
Also, for Motown and James Brown, Box Sets are better way to hear their Music, although James Brown has several Great 2 CDs Sets for his Singles and a few Great Live Albums, especially Love Power Peace. There was a Great 4 Part Documentary on the A & E Network on James Brown that came out around February 20 this year, and is excellent.
Since, I mentioned above a Few Music Artists with 4-6 Great Consecutive Albums, I am not including them below, but those Albums do rank among my Favorite Ones.
Self Titled & Strange Days-The Doors
After Bathing at Baxter’s & Crown of Creation-Jefferson Airplane
Revolver & Sgt. Peppers-The Beatles
Self Titled & Loaded-The Velvet Underground
Self Titled & Abraxas-Santana
CTA & Chicago II-Chicago
All Day Music & The World is a Ghetto-War
Who’s Next & Quadrophenia-The Who
Transformer & Berlin-Lou Reed
The Man Who Sold the World & Hunky Dory-David Bowie
Ziggy Stardust & Aladdin Sane-David Bowie
Station to Station & Low-David Bowie
Lodger & Scary Monsters-David Bowie
Selling England by the Pound & The Lamb Lies Down on Broadway-Genesis(Peter Gabriel Era)
Marquee Moon & Adventure-Television
What’s Going On & Let’s Get It On-Marvin Gaye
The Smoker You Drink, The Player You Get & So What-Joe Walsh
That’s The Way of the World & Gratitude-Earth, Wind & Fire
All ‘N All & I Am-Earth, Wind & Fire
Faces & Raise!-Earth, Wind & Fire
Millennium & In The Name of Love-Earth, Wind & Fire
Born to Run & Darkness on the Edge of Town-Bruce Springsteen
All Mod Cons, Setting Sons & Sound Affects-The Jam(needed to include 3 Albums)
London Calling & Sandinista- The Clash(Sandinista might have some filler, but it is an Essential Album)
V & VI-Brass Construction
Permanent Waves & Moving Pictures-RUSH
Self Titled & Wild Planet-The B52s
Unknown Pleasures & Closer-Joy Division
Off The Wall, Thriller & Bad-Michael Jackson(needed to include 3 Albums)
The Dude & Back on the Block-Quincy Jones
Black Sea & English Settlement-XTC
Skylarking & Oranges and Lemons-XTC
1999 & Purple Rain-Prince
Parade & Sign ‘O The Times-Prince
The Black Album & Lovesexy-Prince
Seventeen Seconds, Faith & Pornography-The CURE(needed to include 3 Albums, as they were a Trilogy)
Kiss Me Kiss Me Kiss Me, Disintegration & Wish-The CURE(needed to include 3 Albums as all are Excellent)
The Dreaming, The Hounds of Love & The Sensual World-Kate Bush(needed to include 3 Albums)
New Gold Dream(81-82-83-84), Sparkle in the Rain & Once Upon a Time-Simple Minds(needed to include 3 Albums)
The Hurting, Songs From The Big Chair & The Seeds of Love-Tears for Fears(needed to include 3 Albums)
Self Titled & Rio-Duran Duran
It’s My Life & The Colour of Spring-Talk Talk
Spirit of Eden & Laughing Stock-Talk Talk(Post-Rock Albums after their Brilliant Transitional The Colour of Spring)
Let It Be & Tim-The Replacements
Surfer Rosa & Doolittle-The Pixies.
Faith & Listen Without Prejudice Volume 1-George Michael
Psychocandy & Darklands-The Jesus & Mary Chain
The Perfect Prescription & Playing with Fire-Spacemen 3
Nothing’s Shocking, Ritual de lo Habitual & Strays-Jane’s Addiction
I need to post this list and come back soon to add 2 Consecutive Great Albums from the 1990s and Post 2000s, as there are a lot of them in my CD Collection(although recently started buying Vinyl for certain Albums depending on who Mastered them and the Pressing Quality). The 1990s has the Largest Number of my Favorite Albums especially Rock from UK Music Artists and Hip-Hop from US Music Artists.