As noted in a comment to GamesRadar+ by the founder of collectibles marketplace Goldin, Ken Goldin, "The Lord of the Rings Magic: The Gathering card is the first true 'one of one' card issued in a major TCG product
Red doesn't have too many, but there are some can't-miss cards like Rhythm of the WildRhythm of the Wild and Temur AscendancyTemur Ascendancy for when you gotta go fast
The last way to play, at least that I know about, is Booster Draft, and the Magic: The Gathering Final Fantasy Bundle Box would be a great way to check it out
These cards feature all the amazing styles I've been showing off today and are your best opportunity to get a traditional foil version of a Booster Fun treatment that you have been looking for
Using the Book of Vile Darkness in combination with the Hand and Eye of Vecna, you can call him forth as an 8/8 indestructible Zombie God who can draw you cards, create Zombie tokens, and buff himself or another creature once per turn