I think you can see from all of these choices, the best solution is the one that works for YOU and your home. Just make sure you create an environment that makes you feel creative and excited to work. And while there are amazing workshops online for inspiration, don’t go crazy thinking your work area needs to be a renovation in and of itself! Use bits and pieces of inspiration, then get going on your projects!
My second shop (2012) is where I started this whole YouTube and website venture. I was maintenance at an apartment complex which allowed me the opportunity to clean out a junk apartment that was previously used for storage and use it as a shop. At that time the only woodworking tool I had was a Kobalt 10” sliding miter saw from my previous shop. I used it to build my wife’s grandmother a 2×4 sitting bench and the positive feedback from friends and family fueled the fire to get back into woodworking. I took an initial $200 investment from my household income to batch out a bunch of them to sell. That investment and a lot of sweat was the beginning of a snowball that has become my shop.