When the applications don't experience errors and end-user experience is satisfied about performance, I would leave it to the engine's db level ( 150 in your case ).

Before altering to...

Did you enable Instant File Initialisation for the service account ? ( on all nodes ? )

Schedule (task scheduler with express edition or sqlagent ) a powershell script that fetches all databases file sizes and reports ( send an email ) when your tresholds are met.

indeed, you'll need to address and monitor tempdb to cope with the rcsi.

Altough, I must admit, we didn't have much problems after enabling it and are using it since it...

Depending on the load of your instance/db, you could try to save the day creating a daily snapshot database and keeping that for a couple of days.

This may not cover...

of course, you can also have a server level login trigger that bounces Windows Authenticated connections

What's the startup size of your tempdb ?

How many files compose tempdb?

Are they equally sized ?

I would indeed never have it fill up a disk/volume, so you can still enable...

Define your sort order to determine "first"

only key columns of an index are used to filter directly on index access

Filters using included columns are only applied after key columns have been processed ( stage 3 )

Included...

I've only seen these dbs file grow during application of cumulative updates.

So, I've never worried about them

Did you perform a SQL Server upgrade (cumulative update) on your SQL2022 ?

If not, at what frequency do you notice these small grow events ?

Maybe this can get you towards your quest

Declare @string varchar(160) = 'LUMBAR - FUT MEDSª, INJURED LOWER BACK LIFTING DRUG BOX'
, @position int = 1

Select len(@string) len_String,...

You have discovered why most of us dislike linked servers !

How did you declare and configure the linked server?

e.g. did you enable "collation compatible"?

Keep in mind data transfer between your...

Does this provide usable info for you ?

SELECT 
    ar.replica_server_name, 
    adc.database_name, 
    ag.name AS ag_name,
  ...

I've always advocated against inplace upgrades ( as it may leaves potholes or ports , ... open / active )

I suggest actually migrating to a new OS with the SQL...