For example, I have a potential client that has decent unit with a solid location but the decor/furnishings remind of a frat boy out of college meets IKEA/Amazon.A unit like this will suffer from poor design and the reviews will show as well which I do not want affecting my reputation or Super Host status.Do I just decline taking them on if they are not willing to work on it?

See what you're comfortable with and then you just gotta commit to narrowing yourself to 1 or 2 markets or you'll be in decision paralysis forever!

Frankly, I wouldn't feel comfortable owning a condo long term due to rising HOA costs and major assessments.

I've done research in finding and analyzing properties so I feel somewhat comfortable in that regard.Here is a sample scenario below of a real property I've done some analysis on.

I have a good network of service providers for work, design, questions about permits in the local market, etc. if you want to connect.

For me, this statement is key, "The owner designated you as agent for the purpose (among others) of finding a tenant.

It's a lot more comfortable being an investor that incorporates all aspects of investing in real estate, in the context of “time”, but I guess that is what makes the top 1%.

@Alan Asriants, my wife, who is a designer, and her other design focused friends, refer to these as "Dude Flips".  

If Airbnb is an option for your spare bedroom then that's great, personally when I first started I didn't want to have to deal with the in and outs of people and also making my place aesthetic enough that it would rank well on Airbnb so I went straight to long term rentals but if you want to dip your toe in the water it could be a good option if shorter term tenants make you more comfortable. 

Or you could self manage sub contractors yourself depending on your comfortability level with that.