A plan to build three “urbanising” houses at a scenic Herefordshire spot has been knocked back.