If I were 65 and living with just my wife, the idea of taking care of a 4700sf RSF house with acres of landscaping and long drives to go anywhere sounds pretty bad.
As for investment purposes, annual costs will be higher in RSF and it seems like the mid to high range there can take 6-12 months to sell, adding a major cost.
I love landscaping now, both doing some of it myself and supervising others. But I am in my 30’s and dealing with much smaller lots. 5 acres in my late 60’s sounds like a continuous chore. My grandmother has too much stress maintaining her 2500sf house on 1/4 acre despite family help, and I know she gets gauged on some maintenance tasks.