I love weird lenses too 
First: Your Canon EOS system is a better choice than Nikon DSLR, but much worse than Sony Alpha 7 series.
For tilt you need a medium format lens and a tilt adapter. I am not very happy with my cheap Ebay tilt adapter on the Sony Alpha 7II. No smooth tilt correction and small tilt angle. My DIY tilt lenses
for Canon Crop DSLR where much more fun.
The
Meyer Trioplan 100
is in fact very popular for its bokeh and glow. It is my favourite lens.
Lenses like the Nikon Defocus Control Nikkor 105mm/2 and 135mm/2 or cheap Meyer Primotar 135 give
soap bubble bokeh
too. Or some cheap projection lenses. Other lenses gives such background structure too, but all a bit different: Meyer Primoplan 58/1.9, Petri 55mm/1.8 (at least the older ones), Accura Diamtic 35mm/2.8, Wirgin Edixar 85mm/1.9 and some others.
You can even modify an old Sigma lens to give you
bokeh control like the Nikon Defocus Control
!
Mirror lenses could be fun too, especially the shorter ones!
The Minolta 250 shall be great, but is very expensive. I work with other mirror lenses. But sharpness could be a problem.
For special bokeh I even started tinkering my own lenses, here an example of a really weird lens:
Or a bit less weird, but with special pronunced bokeh
See here for discussion:
https://photography-on-the.net …read.php?t=1411882&page=1