I don’t think that’s a terrible idea but the buffalo bike is way overbuilt to be essentially maintenance free. IIRC, it even has thicker tubing than needed just to make it easier to weld things to it. This makes it great for poor, rural, developing countries. But its like 50 pounds. I’d rather have gears and the ability to carry it around at the expense of occasional maintenance. In America, it’s easier to find parts, tools, and bike shops to keep a bike running.
When I was a kid, I heard that leaving cut grass on the ground was better for your lawn. Surprisingly, this was enough to convince my dad that I didn’t need to bag the clippings when mowing.
A hybrid bike would be a great place to start. Your first bike is rarely your last. As you ride it, you’ll gradually learn what you like and don’t like about it. Some things can be replaced or upgraded. Eventually you’ll have a better idea of what to get for your second bike. If you’re buying used, make sure there are no signs of rust, the brakes and shifters work as expected, there are no squeaky or metal-on-metal sounds, and the bike is appropriately sized for you, and you should be good to go.
Also, you don’t have to do all the maintenance yourself. Bike service is usually pretty cheap. Some things I do myself, but when it requires special tools, the bike shop makes more sense.
Maybe even some threaded rod with nuts and washers at each end.