Excerpts from your initial post and my reply comments - from the perspective of someone who has done rehabs for 20 years, has been a landlord for 30 and a licensed agent for 10:
"For years now, we have all known that a good portion of the traditional real estate agents job is unnecessary." Well, for you maybe, but for many who do not have significant experience and lots of transactions under their belt, not so much.
"This is a heated topic for a lot of people particularly if you are an agent." Yes, it can become heated, because the one usually cutting down the agent community has either had terrible experiences with prior agents, or has a great deal more transaction experience than most and just don't see the price vs. value relationship. In other words, don't lump all agents into one basket with your comments. Some agents suck for sure and some are creme of the crop, while others fall somewhere in-between. When you agree to hire an agent, you must handle this just like any other employer/employee relationship, which is to find the best match for your situation. So, if you have had a bad experience, I would suggest re-visiting your own qualification criteria, including your interview questions and how your verify their answers.
"The best argument for the traditional agent in my opinion is that some individuals have the ability to be in the deal flow, have good relationships with vendors, lenders, escrow agents etc. and know how to negotiate on behalf of the client." You want/require agents to have relationships with vendors? Only when I represent newbie investors has this ever been important, because, well, they are new and don't have any yet. Most seasoned investors have their own and could not care less about mine. Escrow agents, etc., sure. But if you do lots of deals, you will want your own because they will give you preferential treatment, as well as discounts which may not be available from an agent. Lenders, maybe, but all the rules on this changed right after the banking crises of 2008 - 2011. Lenders/originators were then required to be separately licensed and, for the most part, agents are hands-off and definitely arms-length. Do they know multiple lenders who can successfully close your deal, absolutely, but they are not supposed to get more involved than that. How negotiate and how to navigate the market and certain types of listing agents? Yes, this is where a lot of the rubber meets the road for sure. Some are exceptional negotiators, but most are order-takers. As the buyer, you need to be an active participant and have your numbers down, dead to rights. No exceptions on this.
"Since everything has been moving remotely, the enormous fees agents have been getting has largely stayed in place due to the Lobbying powers of the NAR and belief that an agent can truly be the best financial option. Its taking awhile, but slowly over the last 10 to 15 years some of that has been chipped away. Discount brokerages, FSBO websites, etc. I wonder if this is the last straw?" Again, enormous fees are a bit subjective as inferred above. Some clients need more hand-holding, hence, higher commissions and more time may be required. If you require little hand-holding, then perhaps your chosen agent will negotiate with you something more agreeable based on what you need and their time involved. Keep in mind though, that many states have rules about "limited service" and other variations in the agency relationship that the Real Estate Commission in your state requires of all licensed agents. In other words, the agent may not have a choice to act as a consultant, who might provide only certain services.
"My question, is this the end of the traditional agent? If most everything is being done remotely right now, how long will it be before agents start getting cut out of deals?" The market will decide what happens to traditional agents for sure. Those agents that don't embrace change will simply go away, but I can tell you with confidence that unless a buyer is really sophisticated and does lots of deals, you will always benefit from having a good agent in your corner. He/she may not be worth 6%, but there has to be a happy medium that satisfies both sides somewhere between $0 and 6%, right?
"I can guarantee there's not going to be many open houses this summer. LOL" Open Houses serve one master -- the listing agent, who depends on these partially to bring in their next buyer or seller client. Less than 7% of all sales are the result of the buyer showing up at an OPEN. If you engage the services of a listing agent, just know that this is partially how they keep their business alive. These days, Open Houses are virtual, via 360 or 3D tours and other digital media. So, listing agent will still get leads in this fashion. Besides, as a buyer, why does this matter?
------------------------------------------------------------------------------
Moral of this story is to seek an agent that compliments you and your need. They are a valuable part of any real estate investment team, but as with any employee, take care in your selection.