Well, I have had clients ask for homes on corner lots and cul-de-sac lots. I have never had someone ask for a middle-of-the-street lot, but that doesn't mean that there are not any people that may prefer to have neighbors on both sides.
I used to have a neighbor that had a corner lot and every weekend he always had trash to pick up from people throwing it out their windows while turning at the corner. This was in a nice neighborhood, but it seemed to always happen on this particular lot.
When you find the house that you feel comfortable living in, the lot location will be a distant memory. However, a lot of families with young children do prefer cul-de-sac lots, so you may want to consider that if you have small children or for future resale value.
Thank you for your question and best wishes to you and your family wherever you are on the block.