The most obvious ramification is that you generally don't want to bring a character in that's too far away tier-wise from the rest of the party, assuming roughly equal talent between you and the other players.
So the first implication is that it misleads and deludes people, by telling them that Rogue would really prefer a Barbarian in their party, not some kind of filthy Wizard that casts Glitterdust, because the no one wants a filthy Wizard around!
Yep, kind of proving the the point that the Tier system is bad and terrible and deludes fools.
So, using only that heuristic as a guide, as opposed to personal preference factors, one can say that they'd prefer to play an archivist to a beguiler in a party with a wizard, a cleric, and a druid, and they'd prefer the beguiler when the other party members are a warblade, a totemist, and a dread necromancer. party imbalance is one of the core things the tier system seeks to address, and following the system's rough guidelines will likely get you closer to that result than you would otherwise
So it sounds like what the Tier system is doing is making sure the party is imbalanced because of it's own dumb failures. If the same player could play either class, the same player would be more balanced in both parties of:
Beguiler/Wizard/Cleric/Druid and Archivist/Warblade/Totemist/Dread Necromancer
Than with Beguiler and Archivist reversed.
If they player isn't going to jump through hoops to spell acquisition, then the Beguiler bring trap finding, diplomacy, and spontaneous casting of pretty good spells, and maybe a minion army. Where the Archivist casts like a shitty Cleric who wakes up every day with fewer spells per day or worse save DCs, pick one.
If the player is going to jump through hoops to spell acquisition, then the Beguiler spontaneously casts from a huge list of really good spells and can easily keep up with Wizards and Clerics and Druid, and the Archivist is like a shitty Wizard who has fewer spells per day or lower DCs and also knows a couple good Druid spells, and an occasional other spell at a low level.
In both cases the Archivist is the odd man out in the Wizard party, where he doesn't contribute much, where the Beguiler always has something to do. In both cases the lower level party is a perfect fit for the Archivist, where the Beguiler would, if anything, remind everyone else how little he needs them.*
*Dread Necromancer excepted, since it's just like the Beguiler, but if the Dread Necro is a different player, it could be played at a lower optimization level.
And that's the point, the Archivist is just not a "higher tier" class than the Beguiler, it's a special snowflake class that JaronK liked, so he said "well obviously the DM is going to let you contract a 12th level Warlock make Divine Scrolls of Divine Bard Spells and Alternate Spell Source Assassin and Trapsmith Spells because it's a special Tier 1 class, and Tier 1 classes are VERSATILE!" But then he didn't like Beguilers so he turned around and said "What of course not, no Beguiler every spends feats or PrCs for more spells to cast, they definitely don't get their first Prestige Domain at level 2 and then use the Substitute Domain Spell to repick domains whenever they want and then spontaneously cast off the entire Cleric list! That's optimization, and filthy bad Tier 3 classes don't do optimization to expand their spell list!"
Which then leads to people, 8 years later, claiming with a straight face that if a single player has a choice between Beguiler and Archivist, that the exact same player will someone optimize the Archivist a different amount than the Beguiler, because the Beguiler expanded spell list tricks are "Just totally out there man" and the Archivist tricks are "Just something you do if you are an Archivist."
The other ramification touches on the kinda thing you were talking about, except people don't necessarily place a premium on higher tier. Some people like the sort of game play that tier one promotes, highly deep and complex on a mechanical level with a ton of counterplay, some prefer something around tier three, where you have a solid but not overwhelming quantity of options and can often find a way to participate, and some prefer one of the lower tiers
I think you are basically just proving Soro_Lost's point. You actually believe that different tiers produce different playstyles. This is literally you falling for "Lancer is the best piece" hook line and sinker. There is nothing about being a Dread Necromancer or Sorcerer or Wizard that creates a different playstyle. And playstyle choice comes later when you choose to band Planar Binding from the Dread Necro in your head cannon because he's not Tier 1!