User complaining the query taking more than 50 sec to execute
Object11(Column42, Column54) INCLUDE (Column17, Column53, Column52, Column51) Object11(Column54) INCLUDE (Column42, Column17, Column53, Column52, Column51)
The Scan that's feeding the Aggregate might be worth considering for a ColumnStore Index if the data is mostly insert-only, or having an indexed view to have the aggregates pre-calculated.
There are also a bunch of TVFs that I can't see the detail of. And without the statements, which have been shrunk right down to simply "Statement1" and "Statement3", I can't suggest rewrites. But sorting out Object11 is definitely going to be useful. Start with creating the first of those indexes to see if the impact is significant.