Enjoy The Longest Journey, lostlibrary! It's generally considered one of the best adventure games ever made.
If you like it, you can always play the sequels as well, if you don't mind the different controls and the action elements of the first Dreamfall. Dreamfall Chapters is a better game than Dreamfall, I think (no combat/action and more in depth characters) and also my favorite in the series, although that's not a popular opinion.
The first one (The Longest Journey) is objectively still the best game as far as gameplay is concerned.
The Raven is a terrific detective game, you should enjoy that one.
Since you mentioned detective games, have you played Murder on the Orient Express? I'm not sure if you would be interested, as the only place it appears to be available is here as a disk version -
https://www.amazon.com/Agatha-Christie-Murder-Orient-Express-PC/dp/B000GCGQ6Y. I'm not sure which version of Windows you have? I have a dual boot with Windows 7 and 10 and play this particular game on Windows 7. I haven't tested it on 10 yet, so I'm not sure if it would work or not. I can try it if you're intersted, to see if it will run.
If you don't mind retro graphics, The Blackwell Series by Wadjet Eye is excellent. They are mystery games of a sort that involve ghosts and are available on both Steam and GOG.