A lot of people seem to just jump on the hate bandwagon for Photos. A few do the same for LR, to be fair.
Photos has lens corrections for the
major stuff (Canon, Nikon, Sony, Tamron, Sigma, Fuji, Panasonic etc). If you have some older, obscure lenses, the DXO optics extension should cover your needs unless you custom grind your own glass.
LR is more powerful than Photos for editing. If that is power you need, then you need it. If you are mostly doing minor tweaks to exposure/sharpness/shadows/highlights/Color, Photos may serve you well. High Sierra offers external editors (I bought an extension early this year to do the same) so that you can send images in need of more serious work to Affinity/Pixelmator/Photoshop/whatever your hear desires.
Now if you have a lot of images that need more than Photos but less than Photoshop, but can be serviced by LR, then that may be your best workflow.
It is kind of the same with organizational stuff. Do you need everything LR does? I can usually find what I need with a couple of keywords and a vague idea of the year. For one thing, Photos is blazing fast to scroll through images.
As with anything, you will get more out if you put more in (key words, organization, albums, smart collections).
On the bright side, Photos came free with you OS. There are no feature limitations, no time restrictions, and no watermarks.
Take a few images and import them while leaving the originals where they are. Turn on the advanced options to give you better control over editing, and see how it does for you.
If you absolutely love star ratings, you will probably no like the hack it takes to emulate them in LR.
If you absolutely love easy syncing between your devices and OS integration, Photos is really good at that.
If you mostly do basic edits, Photos will do the job.
If you do a lot of work with brushes and local adjustments, Photos will probably not make you happy.
Try it and see.
The Apple RAW processor has always been a good one. Photos uses the same system Aperture does (the Apple one).