I powered down my Pi 4 with the shutdown operation, waiting until the screen turned black, then waiting for the LEDs to stop blinking with only one red solid led, then unplugged the power source.
I powered it back on and it started failing with Failed to open device: 'sdcard' (cmd 371a0010 status 1fff0001)
I tried re-flashing a new microSD; I tried to flash a Bootloader "SD card boot" with the Raspberry Pi Imager and even this card result in the same result.
Please help! Did my 100$CAD Raspberry Pi 4 just got busted, can it be so fragile??

Is there a warranty?not for damage you may have caused - you yourself say it worked before you power cycled - assuming you haven't left out anything between removing the power and re-connecting the power it's quite odd that the sd card reader failed. When you boot using USB, can you plug in the SD card and read it? Perhaps, somehow, your eeprom was flashed to not boot from SD card before you powered down - though that too is unlikely as clearly there is an error condition trying to read the sdcard – Bravo Feb 03 '22 at 09:35