Tabletop, DnD, board games, and minecraft. Also Animal Crossing.
Rules
I don't remember much about it except it was x-files themd, but I recall Thimbleweed Park being fun.
I remember Broken Age starting off strong, but I feel like they cheaped out at the end when their kickstarter funding ran out.
And it's not quite a click and point adventure, but I loved Oxenfree
Neofeud and it's sequel. Strangeland, Primordia
Came here to recommend Primordia. Beautiful and touching world
The new Monkey Island, Return to Monkey Island or something like that.
THERE'S A NEW MONKEY ISLAND?!? 
Yaaaa, it's good! And very fan-servicy with references to the old ones.
Along those lines too, Thimbleweed Park?? Its a newish Ron Gilbert jam, very cool/weird story with overt X-Files theming. Some pretty difficult puzzles to boot. Plus a very sweary clown.
I thought NORCO was pretty good and pretty surreal too.
https://store.steampowered.com/app/1221250/NORCO/
Kentucky Route Zero doesn't get enough love
I will second NORCO, its a sci-fi bayou adventure with some really touching moments
Spoilers for NORCO
"Its alright, that you wanted to is enough."
Also I will throw in Dreams in the Witch House (2023) by Atom Brain Games, its a very entertaining point and click based on the eponymous Lovecraft story, it has some moon logic but it kind of fits with the whole "You have no clue what the hell is going on" vibe anyway. The creator is currently working on a Dunwich Horror one too.
I feel like there is a whole indie scene here, but most of the point-and-click games that I know about fall into HOG Nancy Drew style detective stuff.
Unavowed was fun. Wadjet Eye actually only makes point and click adventure games and one or two others by them has been mentioned already. They can be a bit weirdly obsessed with the city of New York, but no one is perfect and the games tend to be fun.
I play machinarium and syberia on loop and weep
The detective grimoire series is great. Newest game just came out a week ago. But i would still start with secret of the swamp
I hear Esoteric Ebb is pretty good, though I haven't played it myself. It's supported to be some sort of cross between DnD and Disco Elysium.
Neofeud! The dev Silver Spook is really active on Fedi, too.
Book of Unwritten Tales 2 is the most modern I played but it's eleven years old at this point. time flies
fun game tho, if you haven't.
Submachine has a "remastered" edition on Steam nowadays. Its very very good.
Ohh, I played those back in the times of online flash games! I remember the name of the lighthouse keepers cat.
I've been sitting on Harold Halibut for a while, looks like a really wild existential adventure built out of handcrafted claymation stuff (or something like that).
The drifter. Aussie scifi adventure. No moon logic.
seconding The Drifter; cool story, nice puzzles, full voice acting
and for a point and click it sure has satisfying controls
I loved Gemini Rue, but that was 15 years ago
by modern do you mean the game design or just new releases? if you mean new releases you can check out Grundislav Games catalogue. the two games i have played are Lamplight City and their newest game Rosewater, which is a sequel to Lamplight City. they're solid albeit old school in their design which i personally like.
The Excavation of Hob's Barrow if you're a stickler for the tropes of point and click.
Beyond that you'd have to compromise on the genre.
Somebody on this site told me about https://store.steampowered.com/app/1603980/If_On_A_Winters_Night_Four_Travelers/
It's short, point-and-clicky, and poignant.
I think there are some on Steam but it's not really my genre. If you know how to use search filters, I bet you can find some, and finding a couple will let you look st "related games" and you should be able to get a few that way.