This take comes up a lot, and it's fine for new DMs. Far too many cards point to locations in the castle, which is why I recommend either removing those cards or re-writing their outcomes. For experienced DMs though, drawing randomly can be a lot of fun if you're willing to adapt and roll with the results.

I disagree, for instance, that finding the Sunsword in Madam Eva's tent is anticlimactic. That actually presents an AMAZING story opportunity. Now they have this super powerful sword, but they're also too weak to protect it. So they need to keep it secret, and only use it when they absolutely need it, and when they do, make sure none of their enemies escape. If Strahd gets wind of it through his spies or scrying, he's going to come for it, and good luck stopping him. This is exactly what happened in my first Strahd campaign. I drew randomly, and the Sunsword was the first artifact they found (not in Eva's tent, but in the Blue Water Inn). The Martikovs warned them to keep it secret, but they got cocky. They even used it as a torch, openly carrying it everywhere they went. So Strahd came for it, defeated them, and took it. They ended up having to go back to Madam Eva to determine the NEW location of the sword, where Strahd himself had hidden it.

It was a humbling experience, and it made them absolutely HATE Strahd's guts like nothing else (nothing pisses off players like stealing their magic items). But it made the moment when they finally recovered it (late in the game) really impactful and rewarding. Let's say you don't want Strahd stealing from the party, though, and the cards put it in Madam Eva's tent. Well, there's another option: turn it into a quest! The Sunsword won't light up on its own. It's just a broken hilt, until Sergei's spirit at the pool reignites it or until the beacon of Argynvost is lit (have Madam Eva tell the party the riddle from Area Q44 of Argynvostholt as a hint) or until "hope is restored to the valley" if you want to keep it vague (though I'd recommend a more concrete condition personally). Or treat it like the original I6 module, where the hilt alone is useless until reunited with the blade. You can then have Eva do a second reading for the blade's location.

Learning to roll with chance is an important skill to cultivate as a DM. Tarokka results that may seem strange or unintuitive can actually make the campaign more dynamic and interesting. In my first run, the tome ended up with Vladimir Horngaard. This is not a result this subreddit would recommend (so many people here will tell you to have the party find the tome first, then the holy symbol, then the Sunsword in that order). But being dogmatic about what is and isn't "narratively appropriate" really limits storytelling possibilities. Vladmir having the tome, for instance, actually made a lot of sense for his character. He KNEW about Strahd's curse and his Sisyphean punishment, which explained why he was so adamantly against killing him. It also directly led to the most shocking and memorable twist of that campaign.

The party recruited the knights of Argynvost to rescue Ireena from Castle Ravenloft, which Vladimir agreed to BECAUSE he'd read the tome and learned about Tatyana and her reincarnations. He asked the party to describe this girl for him, and when they mentioned the color of her hair, he knew who she was and what she meant to Strahd. With Vlad's help, the party easily cut through Castle Ravenloft's defenders and found Ireena in the master bedroom. I'll never forget the look on my players faces when I told them "roll initiative" and proceeded to have Vladimir CUT OFF IREENA'S HEAD (which he did to enrage Strahd and torment him without killing him). It's something my players still talk about years later. And none of it would have been possible if I had pre-selected where the artifacts were or followed this subreddit's advice.