First I should mention what I believe constitutes an excellent realtor. That would be one whose primary concern is the best interest of the client (even when the client does not know exactly what that is). Also, an agent who is there for the client after escrow and they have cashed their commission check. In my previous home buying and selling experiences these are a couple of ways I distinguished a good agent from a bad one.
The house I ultimately purchased, I saw in person once prior to a quick two week escrow. Everything else was done via Dan or online. Dan took care of meeting the handyman who "checked out" a light which did not work (and billed me the $140) and claimed it was fine. It has never worked. Dan also purchased a garage remote (which he billed me $35 for) because the garage door was having issues. The remote has also never worked.
Most importantly, during my visit to the property I noticed there was a nice family on one side, an empty lot on the other and a couple of OK properties across the street. What I didn't notice was the large population of pit bulls (one of which has already gotten loose) and many, many neighbors who have trash in the front, side and back yards.
Unfortunately, I am now in a house I will probably never be able to unload. 99% of this is, of course, my fault. But, I have no doubt that if I had a realtor who was patient and interested in more than a quick escrow I would have found our perfect retreat. There were several homes that cost just a bit more in beautifully maintained neighborhoods.