I have been using a raspberry pi 4 B 4GB as a desktop for over a week now and have never fased any difficulties what so ever and everything is working flawlessly.
This sbc is truly a desktop replacement for me.
Now I am thinking to sell my old Ubuntu desktop.
Also all of the programs I used on my old desktop work fine in raspbian.
I heard that the SD card may corrupt if pi is directly powered off, so I have already prepared a secondary SD card.
After all is there any case in which I might need my old desktop.