Up here in Canada you need to pass a Flight Review as well as an exam to get your Pilot Certificate - Advanced. The flight review process seems to be a bit Wild West at the moment with authorized flight reviewers able to charge what they think the market will bear (I've seem posts here of people being quoted $150 for a review, others $500). I like the idea but think the rates need to be fixed (like drivers license exams).
Ordinary hobbyists up here need to pass an exam to get their Pilot Certificate - Basic just to fly (limits: below 400', uncontrolled airspace only, >100' from people, >5.6 km from airports, etc). I passed that exam last weekend but most of the questions were irrelevant to the kind of flying I'm allowed to do. (Which is a rant for a separate thread.)
It sounds like your Part 107 could do with some endorsements, like drivers licenses have. Or possibly a graduated system, again like drivers licenses. (Ontario licences, at any rate. YMMV.) So someone who just wants to take pretty landscapes or real estate pictures not in controlled airspace could get a certificate that allows them to do that without needing to learn procedures that are irrelevant for them.