A RFID lock is about the same as a cheap keyed lock in my opinion. Let’s compare.
Non targeted attacks.
I could probably open your current lock with a lock pick very easily. Attacking a lock with RFID is a similar risk factor. To open your current keyed lock I would use a raking attack which put in simple terms simulates many different key combinations. To open an RFID lock I would use an RFID fuzzer app with the Flipper. That is the equivalent of raking.
With a keyed lock you would use anti bump springs and security pins. The equivalent to protect a wireless lock would be using NFC or Bluetooth instead of RFID. Some NFC tech is better then others though.
Next let’s look at targeted attacks.
If I were targeting you specifically I would take a picture of your key to bypass a keyed lock. The protection to this is not leaving your key out and possibly getting a lock such as the Everest or Mul-T-Pick(me showing off my skills) that is hard to copy. With RFID I would copy your RFID fob or card. The protection here is RF blocking wallets and not leaving the fob/card out.
Summary
Would anybody actually do this? It’s extremely rare that anyone would pick your lock. It’s just as unlikely someone would copy your fob or fuzz your lock. If you are in the US chances are pretty good you have a window near your door and a thumb turn inside. Most criminals will break the window, reach in, and unlock the lock. You have the same problem with an electronic lock. Alternately they just bust the door in.
Suggestions
For security I use an alarm and a dog to alert me. If you didn’t pay a lot of money for your mechanical lock, you don’t have bars on your windows, you aren’t a target of domestic violence/stalking, you aren’t a celebrity or otherwise important person that may be targeted, RFID may be acceptable. I prefer a lock that accepts Bluetooth or NFC though. It’s not going to be more expensive for a Bluetooth based lock. If you are a person that might be targeted for some reason don’t use RFID.
If you do have any reason to think you are being stalked or were a victim of domestic violence I can make some security recommendations.