I agree that it is most convenient to live upstairs near Kyoto station.
Kyoto station is a business district, where there are more hotels.
Further north is Kiyomizu Temple Scenic Area, and there are many good accommodations in between. Close to the station, the scenery is good and the environment is quiet and tidy.
Recommend one. Snow Reeds Dongshan Luxue, a private villa I used to live in, can be booked on booking. They have their own WeChat official account: Dongshan Luxue Kyoto. There is a lot of information in it, and the second brother sometimes sends some daily cleaning, small videos and so on, which can be seen that he is operating with his heart.