Definitely take a look at what you’re looking to host and what it supports. Support for raspberry Pi and their Debian based pi OS is surprisingly widespread and robust. Not always first-party top-level support robust, but surprisingly adequate for a $35, $50 SBC.

Worst case scenario is still a solid introduction to open source software. Downloading, compiling, installing, et cetera. Some of my earliest projects on the pi involved that. Using the camera module along with the video for Linux subsystem, which wasn’t included or packaged under Raspian at the time at least. Go git project. Make, make install, and party