If you find that macOS and the software for it lead to good productivity, I’d advise against ditching it solely for having to allow unsigned applications to run. It’s a few clicks once per app.
I didn’t use Asahi myself. I’d imagine it works for quite a few people, but I personally wouldn’t use it as a daily driver, because the community support is much smaller compared to popular distributions. I’d get a non-Apple computer for using Linux. You could just try it out though, obviously.