Depth is purely a function of where I am. In NorCal, where I started diving and taught for a number of years, I dove 40' to 80' because (a) that's where most of the interesting stuff is, (b) that's where the light dims (the two are correlated, btw). Monastery south of Monterey is an exception, but the deepest there was 120'.
I've gone to 150' in places like Belize (Blue Hole), but the depth isn't a turn-on for me. I guess I'd go technical if I ever wanted to seriously do Truk, but with 20+ years and 1000+ dives, I'm happy in the rec range.
All of the above is kid stuff compared to tech diving, where you can extend depth and bottom times greatly by adjusting your breathing mix. For me, it's too much worry for not enough attraction, though I admire those that do and bring back cool pics!