Vinyl has greater dynamic range than standard digital (CD, etc) recordings. That means the space between the quietest and loudest passage is greater with vinyl. So on paper, that would seem to make vinyl better.
But wait! Digital has a lower noise floor to begin with, meaning it's inherently quieter (that's assuming the master recording is quiet to begin with), and digital has faster response times which can make music from it seem more impactful. Too impactful for some.
Vinyl has the same challenges it's always had; must start with a pristine album, must be clean, good needle and turntable, etc. When all is perfect, it sounds great, but unless you're buying new vinyl, it can be hard to get good ones.
Which is best? The one that you like is the best. Personally, I think vinyl is too much trouble, and the way I listen (multiple locations from same feed, etc), playing albums just doesn't work for me. I have a computer that is dedicated as a "juke box" with a nice sound card and DAC, an it feeds a distribution amp that supplies my entire house, inside and out. And I can control the playlist from my phone or any device connected to the internet.
Both vinyl and standard digital suck in comparison to High Rez Audio. If you've heard it, it's absolutely amazing!! Even old songs that are remastered in high rez sounds like never before. If you've listened to the sound tracks on BluRays, you've gotten a taste of it. EX: Guardians of the Galaxy; those 70s songs never sounded so good! It's been slow coming to physical media because of all the people who prefer streaming, but we audiophiles are cheering for it to break loose.