I've owned one that was comfortable for all day use (Steelcase Leap V2) and have had chairs provided by work that were similarly comfortable but I also regularly get up and move around.

My favorite chairs ever were these tall stool type office chairs with a ring at the bottom you could put your feet on: They were standing desk height and we all had standing desks. You could sit in them normally or you could scoot forward a little bit and sit kind of like you would on a knee chair. No idea what they were but if I ever get to pick new office furniture, those would be a strong contender.

I might buy that setup for home one day, but I don't think my Steelcase will ever fail me so I'll probably be using that for the rest of my life haha.