Your electrician is right if he advised against WLAN cameras. So you want to monitor your driveway and around the house. Without more specific information, no recommendation regarding cameras can be given. Cameras come in a wide variety of types (resolution, day/night vision, horizontal and vertical viewing angle, pan/tilt, zoom, ... If he offered you cameras for €1,000 each, that was indeed top class (Mobotix, Axis...) or he is charging a lot.
"A one-time video surveillance" is not possible as it depends on the circumstances and how many cameras should be used. I suspect you will find what you are looking for in the €200-300 price range. Unfortunately, I can only provide information about Axis and Mobotix. User can certainly help with alternatives. Then you will also need a device for recording. Motion detection runs either in the camera or sometimes on the recording device. With €1,500 - 2,000 you can achieve quite a bit.
The cameras receive power via the LAN cable (PoE). For this you need a switch that supports PoE, PoE injectors, or a recording device that functions as a PoE switch. Only large camera systems in the absolute high-end range require a separate power connection. Here we are in the four- to five-digit range. Applications are large areas, cities, airports, industrial facilities, high-security applications... You don’t need any of that.
Honestly, I have a bit of "gut feeling" concerns regarding the adjustment of the cameras and recording, as well as the network.
Do you have a LAN connection inside the house near the area to be monitored? Even though it actually goes against all "guidelines" (WLAN, cloud...), take a look at Arlo. It runs via its own WiFi. You could connect them directly to power. It uploads to the Arlo cloud, and the videos are analyzed. The detection is very good (people, animals, cars, packages, motion). Such few false alarms and good detection is otherwise very hard to achieve. Arlo works only if the hub is close to the area to be monitored. If your cameras are positioned around the house, you can forget it right away. Or you need several hubs. But then you quickly reach price regions where it no longer makes sense.
You are required to indicate the surveillance via a sign, and you may only monitor your own property. No public spaces and no neighboring properties. But who sues over small things...
If you provide more information, we will certainly find a solution.