I import from card using my own C program that reads the EXIF timestamps and sorts them into directories using the timestamps for directory and filenames (e.g. "yyyy/yyyy-mm-dd/hhmmss.jpg").
Then I would typically use darktable if I want to postprocess. I shoot 99% JPEG. I'll use GIMP for quick edits.
If I want to share, I create an album in Lychee, which is a self-hosted PHP gallery on my web server.
I've never used Photoshop or LightRoom. I have no idea what they're like.