Personally I find the milanese loop with a magnetic holder is a great in-between for a casual yet comfortable look.
If the watch doesn’t have the standard lugs I get an adapter kit so that I can use whatever standard watchband is on the market so that I don’t find myself limited to specific watchband for that model (smartwatches are bad for this…)
Once installed it will fit however tight you want, and it will loosen itself if it’s way too tight when doing something a bit physical.