M2 Pro 14 with 32/512 is plenty for video/photo/audio in 2026. Resolve and Logic lean more on unified memory than raw CPU, and 32GB is the right call there.
Couple of things to check before pulling the trigger though. Is this a private sale or a store? At CAD$1800 private, get the serial first and run it through Apple's coverage page. Then check battery cycle count via About This Mac → System Report → Power. M2 Pros are old enough now that some are pushing 800-1000 cycles, which still works fine but is past the spicy zone.
One nit on the "cheap to try macOS" angle: if you do decide to keep it, the M2 Pro will keep depreciating faster than an M5 since it's two generations back now. The cheaper buy-in cuts both ways.