You are totally right. I didn't love it. And the river definitely had me really unsure about it and yes the house is way too far from main street.I don't think the house location is cramped, especially since you're going to move out the villager next to you. But if you like being close to Main Street, then you might find it tiresome to travel up there, even if you are running on a path.
Also, if you like to have big setups of PWPs (like a large park or something), the river might make that more difficult, unless you like the idea of a river running through everything.
Unfortunately, the maps you get are so random. It could be that the next reset gives you a perfect map, or it might be 100 resets from now. But if you are having these doubts after just getting the map, then I'd say keep searching.
BUT LOOK, I THINK I LOVE THIS ONE!! It has apples too and triangle grass!