I think Sequoia is fine to use since macOS 15.2. (Prior versions had a bug that prevented firewall rule changes in some cases, which might not have bothered "most people" but sure did bother me...) I'm not having any problems using it as a daily driver, Office works the same as it always has, and battery life seems in line with Sonoma (after initial reindexing is done).
Other issues that I am aware of in Sequoia right now are ...
* In the Calculator app, repeat operations don't work (fixed in upcoming macOS 15.3)
* Full-disk bootable backups cannot be made anymore using third-party tools (i.e. Carbon Copy Cloner) — this broke in macOS 15.2, unclear if Apple is going to fix it, but I hope that they do — though, not too big a deal for me, since it is easy enough to just do a new macOS install and then immediately restore from backup with Migration Assistant.