I’d say that that whether it is good or bad will depend mainly on the route and the type of rider you are.
When I lived in an urban setting and cycled out of town to work I had loads of route options to keep me interested in riding an MTB (went from hardtail to rigid after trashing forks due to lack of maintenance). My idea of fun was charging around off road and down stairsets and small drops. Meant I was often tired out and had to have days where I made an effort to take it easy. I made a few Strava segments and got KOMS etc (thanks wind). There were numerous route variations.
Since moving to a village there’s fewer options and busy roads can’t be avoided without adding more mileage than I usually have time for. The hardtail soon became a soul crushing chore, especially on long straight drags in traffic on dark evenings. I ended up being given a cheap Carrera hybrid, faster rolling tyres pumped up, flat bars, rack, saddlebag, frame bag, to carry everything I need. Much better and leaves me with energy for riding I do enjoy. I’ve only got 3 route variations I regularly take now. Would probably get a gravel style dropbar commuter bike if I could afford it and it was easier to go faster on.