I'm another one who's stubbornly stuck with Aperture all along. I gave Lightroom a try but I wasn't all that fond of it (partially because I couldn't follow the workflow) - I do some basic things in Aperture and then will go into Photoshop when necessary. I am curious about one thing if I make the switch to Photos.. My Aperture Library is 736GB, of course now its stored locally on my Mac and I keep a backup of the library externally. If I import all of those images into Photos is that going to be stored on iCloud automatically? (I do have photos on my phone backed up to iCloud as I have 2 phones and an iPad that I share pics between). I dont want to be forced into a 2TB plan and pay $10/mo.
You can import all photos and keep them referenced exactly the same way Aperture does.
It is working well - I have been using referenced photos for 2 years. Once you decide however to move a photo from referenced to managed you cannot roll it back - Photos will not let you.
Referenced photos are not synced with icloud (only fully managed photos with originals are synced across all your devices). This forced me to finally buy 2TB plan and get all photos managed (80k+ RAWs). Happy for now - yes it costs 10$ a month but gives me kind of backup - additional photos storage in the cloud. When I change my device or upgrade home storage I'm not afraid of loosing photos in the process - I know there is a copy.