As far as I'm concerned, it's all about the journey. I enjoy cycling, usually alone, because I can travel sedately through the ever-changing countryside watching and absorbing what is happening around. And I feel better for having done it. I couldn't feel bored. Pessimistic, worried, or desperate maybe, but only rarely.
The bike is not the method of transport I use if I want to go somewhere. Almost all my rides are circuits starting and finishing at home; I am usually conscious of the point at which I am farthest distant and it's nice if that can be close to a feature such as a bridge or castle, but it wouldn't occur to me to stop and visit. If I did that the bike would become an encumbrance, I would be wearing the wrong shoes and clothes, and I wouldn't have access to stuff I would expect to have in the car.
When I first discovered I could ride 100 miles the combination was immediately perfect; a physical accomplishment I could feel proud of and a satisfying length of time spent in the countryside. More recently, when I thought I couldn't manage 100 miles any more I tried to convince myself that 30 was the new 100, and that it could be just as good, but I never really believed it.
I'm a lot slower than I was and I fully understand the OP's concern about fitting the miles into a day. I've always preferred to minimise stationary time and that helps a lot. Without riding in the dark - not my idea of fun - 200 miles still looks possible but that is getting close to the limit.