Capture One is one of the top photo editing software programs for professional digital photographers. There are two basic workflows to consider: Catalogs, and Sessions. For self-contained projects, such as model photoshoots, or specific product shoots, you may prefer the Sessions route, where everything is contained on one package. For general photography, which may include images from a vacation, family outings, scenic shots etc., the Catalog setup has many benefits. The Capture One Website has plenty of tutorials discussing the differences and best practices.
If you are just thinking about C1, by all means, get the Trial version. It is fully functional and lasts for about one month. Make sure to set aside the necessary time to really check it out ( don't leave it unil you only have two days to evaluate the program). As to cost, yes it is expensive, but I feel it produces excellent results for your digital camera.
C1 does an excellent job of "Developing" your RAW files ... it does not provide pixel editing! For that, you can use Affinity Photo or Photoshop.
RAW files from Camera need to be Imported into C1. Most critical consideration is where are the RAW image files going to live? One option would be to copy the files from your camera disk into a folder on your PC, then have C1 Import from that folder. If you want to keep RAWs in date order, name them YYYYMMDD-subject for example (20211231-newYearsEve). The folders will then keep in date order. All the folders can be located in the Picture Folder.
Import From: the folder you copied RAW files to.
Import To: Select "Add to Catalog". As the note indicates, this will leave the files in the folder - not duplicating anything.
There are additional settings to allow adding Copyright etc.
The second way to Import is to choose Import From - then select the card reader directly. CAUTION: You need to also select where to put the RAW files. Simply allowing "Add to Catalog" will leave them on your Card which of course will be repurposed in the camera and eventually overwritten! (Been there, done that!). In any case, C1 gives a preview of the files to be imported so you don't have to clog things up with the definite losers. This method also allows renaming the files as you import.