You’re seemingly committed to the Microsoft tooling and environment.
You really want a Windows PC for that.
If you want a spreadsheet, or Python, or a database, there are available fine choices for macOS.
But if you want Windows tooling and a familiar environment, you want a Windows PC.
If you meant PowerToys, that runs only on Windows.
As for other tools, Microsoft 365 Copilot (née Office) is available on macOS, but the full Microsoft experience is best available on a Windows PC with Azure.
If you do decide to learn new tooling and different apps, a MacBook Air M4 is a powerful choice. It can certainly handle video and photo editing using available Apple and third-party tools, as well. Mac is quite different from Windows, and in some fundamental ways.
You will, however, want to select as much memory and internal storage as you need over the lifetime of the Mac, as those cannot be expanded after purchase.
You’ll want a hard disk of two or three times the capacity of the internal storage for Time Machine backups as well, or a network-attached storage device (NAS) if you want a mid- or higher-end backup solution that requires less cabling and re-cabling.