You want fun mysteries, anything by Charlotte McLeod will fit the bill.
Also theres a fun series by Gretchen Archers, the Davis Way Cole Crime Caper Mystery series, starting with Double Whammy, soon to be nine books, are a lot of fun. Set in a Biloxi Mississippi gambling casino Davis Way is a female security expert for the casino where anything and everything happens in an often hilarious fashion. She also has a family of kooks to add to the problems, as well as an ex-husband who doesnt help keep things sane either.
Both authors are available on Amazon or Apple Books
I just finished reading a Horror Murder Zany Comedy mystery book by Dean Koontz called TickTock, it was a lot of fun.
I second the suggestion of anything by Dean Koontz, especially the "Odd Thomas" series.
After watching the movie with Jimmy Stewart and Lee Remick, I thoroughly enjoyed reading the book “Anatomy of a Murder.”
OK then, how about Nathaniel Hawthorn - the father of the modern mystery novel.
Or Edgar Allen Poe.
Fools Die by Mario Puzo. Old book and I enjoyed the read.
ping
Chandler's work had a decisive role in developing the modern detective story, with a direct line from Chandler's hardboiled Phil Marlowe of the 1930s and 40s to TV's genial, cynical Jim Rockford of the 70s and 80s. Ross MacDonald's Lew Archer is a more polished version of the hardboiled type, set in the 1960s and 70s. Paul Newman did a good job of playing Archer in two movies.
The cynicism of the hard-boiled type usually offers little room for politics. Robert B. Parker's Spenser series though stirs in a dose of liberalism, which puts him off my favorites list. So also with John D. MacDonald and his Travis McGee series, which tends to have plot points based on issues of the 70s and 80s. The books now seem dated.
Loren Estleman's Amos Walker series is set in modern Detroit with an effect close to Chandler's hard-boiled style. Estleman's writing is well-regarded.
Rex Stout's Nero Wolfe series is an acquired taste, but the writing and plotting are clear and direct. Set in New York in the 1930s to the 1960s, the series avoids politics, with the obese and housebound Wolfe relying on his street detective, Archie Goodwin, to dig out facts that Wolfe processes toward a solution that is revealed in interviews and a confrontation with the main suspects.
Director's Cut by Roger L. Simon is worth reading in that it makes conservative points and is by an author who went from liberal to conservative. Simon's earlier mystery books in the Moses Wine series are good but have Leftism applied like decorations on a cake.
You can try Ngaio Marsh. She wrote the Inspector Alleyn series, some of which were made into a film series.
I can’t believe no one mentioned Perry Mason (Earl Stanley Gardner), seem they would fit your description of what you are looking for.
May I suggest anything by Donald Westlake, especially the Dortmunder series?
My husband and I both read the Bosch series by Michael Connelly. The TV series on Amazon is great too!
Just read some Jack Vance mystery/thriller stories. I recommend the two Sheriff Joe Bain novels.
https://en.wikipedia.org/wiki/Sheriff_Joe_Bain
Freegards
I am currently taking a class on A GENTLEMAN IN MOSCOW. I read scifi, historical novels and history. This book is different from my usual style .but easy to read and is thought provoking without getting too deep.
"Tea and crumpets" mysteries and a high standard for writing -- one of the first woman graduates from Oxford.
The novels go in chronological order but may be read separately.