What trains have 'bogie wheels'?

Not very common, but there are some.
 
First, as you have said, there's the Dr Yellow one that has a camera (discontinued).



As well as the Jurrasic Park train (probably discontinued).



Then, there are three train sets you can buy brand new right now if you like to, those are:

S-34 Car Transporter (bogie on the car transporter part, not the EF65 loco),



S-46 EF510 Red Thunder  (bogie on the tank part, not the loco), and



KF-02 Long Tank Container



The hooks are combined with the bogies in the newer ones, so if that's what you're looking for then those three will be what you would buy.

There's also the S-38 Long Container Train!