all things being equal, higher rez files can sound a little better overall. but, of course, all things are rarely equal.
i agree with the whole recording quality being more significant than the digital format, but that’s only half the equation. the 800 pound gorilla in the room is native recording source resolution. that’s where you find optimal sound. i always try to listen to the least mucked up source. this goes equally for analog too. give me 1/2" 30ips tape if that is what the recording started life as, or redbook if that’s where it started. direct to disc vinyl is also phenomenal and can compete directly with the best tape.
my MSB Select II has a hybrid dac which optimizes both pcm and dsd whatever resolution. it is astonishingly good on redbook, and does a great job with MQA. but my favorites are consistently the native resolution if i have a way of determining that.
i have dozens of native dxd (352/24) and quad dsd files and those are pretty awesome when the recording quality is also superior. if you think redbook sourced recordings are equal (especially as the music gets more complex) you have work to do.
and not every system will equally reveal media differences. so my experience and realities might not equally apply to all.
YMMV and just my 2 cents.