The whole point of having an agent is to have a partner in your career, someone who gets your writing, understands your goals, and works with you on both. Oh and also sells your books
. I sense some cynicism from your post (well all your posts), as well as a wee bit of a chip on your shoulder, but let me assure you that such relationships not only are possible but are very common. I myself wouldn't trade my agency for anything, not only is my agent fantastic and a great motivator, but the head of the agency himself asked to talk with me just to give me a bit of a pep talk.
Also, again, they are incredible deal makers.
I have a friend who's agent couldn't sell her first work no matter how many times they went back to the drawing board. This agent met with an editor friend who told her what they were looking to buy at the moment. The agent promptly went to my writer friend and asked her if she thought she could write that book. My friend did, and together they put together a fantastic submission, resulting in a 3 book deal with Harper Collins. And they are still working on selling that other book.
Now it can be that an agent and author don't work well together, you do read about that happening as well. And this is where the adage, "No agent is better than a bad agent" comes in. And this is also why it is such a tough job finding that right agent.
Let's also not fool ourselves, authors are so grateful to have an agent interested at all that they are willing to put up with a lot. But they shouldn't, and invariably those authors who are not happy with the relationship eventually part ways with their agent. Many move on to find just the right match.
Agents and their authors often become friends, because they work together for so long.
At any rate, no. The whole point of getting an agent, and the reason the process is so long and involved, is that both author and agent are looking for a long time thing.