I always laugh when someone who has never worked on a farm talks about buying one. Most farming is hard work, much harder than an office job. And most small farms do not make much money, especially if you don't know what you're doing. If you're thinking about it go get a job on one first before you buy anything.
I know some farmers and they all have one thing in common: they work around the clock, 7 days a week. No days off or vacations. Their farms might be worth millions, but it's also both their home and their job. Also, a lot of people don't get that a farm (anything other than subsistence farming) is a business. It requires careful long term planning, crop rotation, dealing with buyers, collectives, auctions, risk mitig…
Yup, it's a full time job, the land doesn't go on vacation.
Yes it can give enormous satisfaction. Every time I'm at the store buying fruit I sigh at how much fruits our grandad used to bring home, for free, it was way better than the fruit I guy at the grocery stores, and it was the surplus from the sales...