For the tasks you've listed, I think you can still get away with just buying cordless electric tools.
For bike tires I use this:
https://www.homedepot.ca/product/rid...ly-/1001547823
They also make nailers like this:
https://www.homedepot.ca/product/rid...ler/1000828866
Other brands have similar offerings.
I do have an oiless compressor (
https://www.homedepot.ca/product/por...sor/1000657974) but it's pretty loud. If quiet is a top priority you should see if the tech for oiless has gotten any better in terms of noise. I don't use it nearly as much as I thought I would.